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.
VishnuRemoveSpaces.zip (20.5 KB)
Use assign dt.columnname(“column name”).expression=row(“column name”). ToString.trim
use Replace regular expression
please find attached workflow.
let me know its worked for you?
Thank you so much Sandeep it worked.
Implemented the same logic in the actual work flow I am working on.
how I can I get only the numbers from the string using regex?
this post may be help you
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.