Removing spaces in Excel

[winningvish (Vishnu Vardhan)]

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)

[AshwinS2 (Ashwin S)]

Hi @winningvish

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

Thanks
Ashwin.S

[sandeep13 (Sandeep Pathak)]

@winningvish
use Replace regular expression
please find attached workflow.

Test.xaml (8.4 KB)

[sandeep13 (Sandeep Pathak)]

@winningvish
let me know its worked for you?

Thanks

[winningvish (Vishnu Vardhan)]

Thank you so much Sandeep it worked.

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

Regards
Vishnu

[winningvish (Vishnu Vardhan)]

Hi Sandeep,

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

Regards
Vishnu

[sandeep13 (Sandeep Pathak)]

@winningvish

Get numbers only from string by using regular expression

Hello guys, I have following string: String str= "COO OPP (404) 851-1331 ext. 1520 " I want to get result as (404) 851-1331 ext. 1520 like this by using regular expression only. Can anyone provide me exact regular expression for the same. Thanks,

this post may be help you