Trim Fields - Data360_Analyze - 3 - 3.12

Data360 Analyze Server Help

Product type
Software
Portfolio
Verify
Product family
Data360
Product
Data360 Analyze
Version
3.12
Language
English
Product name
Data360 Analyze
Title
Data360 Analyze Server Help
Copyright
2023
First publish date
2016

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.