How to replace empty spaces before values in 2 excel columns using Studio X

Help StudioX
, , ,
1

Hello, could someone show me how to remove extra spaces before cell values for two columns of data. I tried using the replace activity and it does not change anything. I am using Studio X.

image

Thank you!

2

Hi,

In this case, we can use ForEachExcelRow and ModifyText as the following.

image
image918×1171 29 KB

Please add same logic for the other column.

Hope this helps you.

Regards,

1 Like
3

Thank you! I will give this a try.
Best,

4

Hi

we can use ForEachExcelRow and trim to remove spaces