Removes leading and trailing characters from field values within the input data set.
By default, the node will remove all instances of the characters specified in the TrimCharacters property. If you want to remove a prefix or suffix string, rather than individual characters, set the TrimCharactersAsString property to True.
You can also filter fields either inclusively (list each field you want to trim) or exclusively (list all fields to ignore), in the IncludeOrExcludeFieldList property.
Properties
TrimDirection
Optionally specify whether characters are trimmed from the left, the right, or both ends of the string. The default value is Both.
TrimCharacters
Optionally specify a string containing characters to be trimmed from input fields. The default value is the space character.
TrimCharactersAsString
Optionally specify whether you want to trim the string value entered in the TrimCharacters property to remove a prefix, a suffix or both.
- When set to True, the node will trim the string entered in the TrimCharacters property.
- When set to False, the node will remove all occurrences of the specified characters.
The default value is False.
IncludeOrExcludeFieldList
Optionally specify if the FieldList is a list of fields that should be included or excluded from the trimming. Choose from:
- Include
- Exclude
The default value is Exclude.
FieldList
Optionally specify the list of fields which are included or excluded from the trim operation.
Example: fields['Field Name 1'], fields['Field Name 2']
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: Trimmed Data.