Trim Value
This transformation removes the blank spaces from around values in a column. The settings are:
Which column to trim values in: Enter the column name you want to remove the spaces from.
Which side to trim:
- Left: Before the values
- Right: After the values
- Both: Before and after the values.