DataFlux Data Management Studio 2.5: User Guide

Parsing Node

You can add a Parsing node to a data job to separate multi-part field values into multiple, single-part fields. For example, if you have a Name field that includes the value Mr. John Doe, you can use parsing to create three separate fields:

• Name Prefix: Mr.
• Given Name: John
• Family Name: Doe

Once you have added the node, you can double-click it to open its properties dialog. The properties dialog includes the following elements:

Name - Specifies a name for the node.

Notes - Enables you to open the Notes dialog. You use the dialog to enter optional details or any other relevant information for the input.

Locale - Specifies the locale within your Quality Knowledge Base (QKB) to used to perform the parsing operation.

Field to Parse - Specifies the field to be parsed.

Definition - Specifies the category of data to be parsed. The list and types of definitions change depending on the loaded locale and the version of the QKB.

Result code field - When selected, specifies that the results of the parsing operation are passed to the output of the node. If no field name is entered, the results will be put into a field named _parse_result_ by default. The possible result values are:

• OK - The parse operation was successful.
• NO SOLUTION - The parse was unsuccessful; no solution found.
• NULL - The parsing operation was not attempted. This result will occur only when a null value was in the field to be parsed and the "Preserve null values" option was enabled.
• ABANDONED - A resource limit was reached. Increase your resource limit and try again.

The Tokens section of the dialog includes the following elements:

Available - Displays the fields that you can make available for the next step in your data job. Items displayed in this list are dependent on your data sources and any preceding steps in your data job.

Selected - Displays the fields that will be made available to the next node in your data job.

Additional Outputs - Displays the Additional Outputs dialog. This dialog enables you to specify the fields that you can make available to the next node in your data job.

Preserve null values - When selected, specifies that null values in the data source are preserved.

You can access the following advanced properties by right-clicking the Parsing node:

• APPEND_RESULT
• BF_LOCALE
• BF_PATH
• EXCEPTION_ACTION
• EXCEPTION_INFO
• FIELD_MAP
• LOCALE_FIELD
• LOCALE_LIST
• PARSE_DEF
• PARSE_FIELDNAME
• PARSE_INPUT_LENGTH
• PARSE_TOKENS
• PRESERVENULL
• RESOURCE_LEVEL
• RESULT_FIELD
• SCORE_DEPTH