Trim String Transformation

Data Transformation Services

Data Transformation Services

Trim String Transformation

The Trim String transformation removes leading, trailing, and embedded white space from a string in the source column and copies the result to the destination column.

White space consists of the following characters: tab, line feed, vertical tab, form feed, carriage return, and space (0x09 – 0x0D, 0x20), as well as their Unicode equivalents.

You may optionally convert the trimmed string to either uppercase or lowercase characters.

If the trimmed source data is too large to fit in the destination column, it is truncated.

The Trim String transformation fails if the source or destination columns are not of a string data type.

To perform a Trim String transformation