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.

Comments

  • @learnx do you have magic ETL 2.0? If so, you can use a formula tile. I believe there is a trim whitespace function.

    **If this answer solved your problem be sure to like it and accept it as a solution!

  • If you have Magic 1.0, you should be able to use the string function tile to trim spaces.

    **If this answer solved your problem be sure to like it and accept it as a solution!

  • @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!**
  • Thanks guys it worked! @Ashleigh and @GrantSmith I have ETL 2.0! Much appreciated !