How to Trim a column with multiple words in it using ETL

learnx · 2021-09-09T17:25:17+00:00

There was an error rendering this rich post.

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.

Find more posts tagged with

@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 you have Magic 1.0, you should be able to use the string function tile to trim spaces.

@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:

Thanks guys it worked! @Ashleigh and @GrantSmith I have ETL 2.0! Much appreciated !