Removes leading and trailing characters from field values within the input data set.
The fields can be filtered either inclusively (list each field you want to trim) or exclusively (list all fields to ignore), based on IncludeOrExcludeFieldSet.
Optionally specify a string containing characters to be trimmed from input fields.
The default value is the space character.
Optionally specify whether characters are trimmed from the left, the right, or both ends of the string.
The default value is Both.
Optionally specify if the FieldSet is a list of fields that should be included or excluded from the trimming. Choose from:
The default value is Exclude.
Optionally specify the set of fields (one per line) which are excluded from the trim operation.
Optionally specify whether to change a field to NULL if it becomes empty after the trimming operation.
The default value is False.
Inputs and outputs