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.
