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

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!

Hi,

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

Please add same logic for the other column.

Hope this helps you.

Regards,

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

Hi

we can use ForEachExcelRow and trim to remove spaces