You can use Magic ETL to remove spaces from text strings.
To remove spaces from text strings,
-
Open Magic ETL.
-
For your input DataSet, select the DataSet you want to remove spaces from.
-
Add a "Replace Text" tile.
-
Under Select a column to search, select the column you want to remove spaces from.
-
Under Enter a term to search for, enter \s.
Note: In RegEx \s is the expression for whitespace. -
Check the box reading Use RegEx.
-
Repeat steps 4-6 for all columns that need to be corrected.
-
Click Done.
-
Add an output DataSet and name it.
Your output DataSet should incorporate the changes.
Comments
0 comments
Please sign in to leave a comment.