Removing spaces in Excel

Help
1

Hello Everyone,

I have used all methods like Trim, Substitute and clean to replace the spaces with empty character but failed.

Please find the attached excel file with the sheet name : Sheet1 and Column L

Can some one please help me on this to remove all spaces within excel.RemoveSpaces.xlsx (9.2 KB)

Thanks a lot in advance.

Regards
VishnuRemoveSpaces.zip (20.5 KB)

2

Hi @winningvish

Use assign dt.columnname(“column name”).expression=row(“column name”). ToString.trim

Thanks
Ashwin.S

3

@winningvish
use Replace regular expression
please find attached workflow.

image
image1011×424 14.6 KB
Test.xaml (8.4 KB)

4

@winningvish
let me know its worked for you?

Thanks

5

Thank you so much Sandeep it worked.

Implemented the same logic in the actual work flow I am working on.

Regards
Vishnu

6

Hi Sandeep,

how I can I get only the numbers from the string using regex?

Regards
Vishnu

7

@winningvish

this post may be help you