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.7K All Categories
- 1 APAC User Group
- 12 Welcome
- 36 Domo News
- 9.6K Using Domo
- 1.9K Dataflows
- 2.4K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 339 Workbench
- 252 Domo Best Practices
- 11 Domo Certification
- 461 Domo Developer
- 47 Domo Everywhere
- 101 Apps
- 705 New to Domo
- 84 Dojo
- Domopalooza
- 1.1K ζ₯ζ¬ζ―ι¨
- 4 ιε ΄-ζ₯ζ¬ζ―ι¨γΈγγγγ
- 23 γη₯γγ
- 63 Kowaza
- 297 δ»²ιγ«ηΈθ«
- 649 γ²γγγε ±ζ