This deprecated node 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.
Properties
TrimCharacters
Optionally specify a string containing characters to be trimmed from input fields.
The default value is the space character.
TrimDirection
Optionally specify whether characters are trimmed from the left, the right, or both ends of the string.
The default value is Both.
IncludeOrExcludeFieldSet
Optionally specify if the FieldSet is a list of fields that should be included or excluded from the trimming. Choose from:
- Include
- Exclude
The default value is Exclude.
FieldSet
Optionally specify the set of fields (one per line) which are excluded from the trim operation.
NullEmptyFields
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
Inputs: in1.
Outputs: out1.