How to Trim a column with multiple words in it using ETL
I need to Trim extra spaces, How can I do that in ETL?
I used the replace text function, but it would remove all spaces.
So, if the column contains " Josh Smith Jarrod ", I want "Josh Smith Jarrod" but I am getting "JoshSmithJarrod".
I am not looking for SQL solution as the end user need it through ETL. Thanks in advance.
0
Comments
-
If you have Magic 1.0, you should be able to use the string function tile to trim spaces.
3 -
@Ashleigh is correct.
Here's an ETL2.0 example
TRIM(`Column`, 'CHARACTER TO STRIP')
If you leave off the second parameter it'll strip spaces by default.
Magic 1.0 example:
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2 -
Thanks guys it worked! @Ashleigh and @GrantSmith I have ETL 2.0! Much appreciated !
1
Categories
- 10.8K All Categories
- 3 Private Company Board
- 1 APAC User Group
- 12 Welcome
- 38 Domo News
- 9.7K Using Domo
- 1.9K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 343 Workbench
- 258 Domo Best Practices
- 11 Domo Certification
- 464 Domo Developer
- 50 Domo Everywhere
- 104 Apps
- 714 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 26 お知らせ
- 64 Kowaza
- 299 仲間に相談
- 653 ひらめき共有