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.

The fields can be filtered either inclusively (list each field you want to trim) or exclusively (list all fields to ignore), based on IncludeOrExcludeFieldSet.

CAUTION:
This node has been deprecated and will not be supported in a future release. As an alternative, the Trim Fields node can be used to provide similar functionality.

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.