Regular expression options on the Configuration tab
Regular expression options on the Configuration tab
When you add a step to a parse asset,
Data Quality
prompts you to define a step with a regular expression or with a dictionary.
The following image shows the options that you configure when you define a step with a regular expression:
The regular expression options includes the following properties:
Add Step option.
Adds a step to the asset. A step describes a parsing operation that a mapping can apply to an input data field.
Up and Down options.
Moves a step that you select up or down within the step sequence.
Step sequence.
Defines the order in which a mapping applies each step to the input field at run time. The mapping performs regular expression parsing operations in the order that you specify.
Option description.
Identifies the type of regular expression in the step. A custom regular expression is a regular expression that you define.
Test input field.
Contains the string that the Secure Agent uses to test the steps in the parse sequence.
Test output fields.
Contain the result of the test. The asset displays an output field for each step and also displays output fields for overflow dat and unparsed data.
Import file option.
Imports the first column of data from a comma-separated file to the test panel.
Step type.
Identifies the type of step to which the properties apply. The step type can be dictionary or regular expression.
Regular expression type.
Specifies whether the step uses a built-in regular expression or a regular expression that you define.
Regular expression field.
In Custom mode, the field contains the regular expression that you specify. You enter the regular expression logic in the field.
In Built-in mode, the field displays the name of the regular expression that you select. Additional fields display the regular expression logic and the number of output fields that you must create.
Output name(s).
One or more outputs to which the step can write each input data value that matches the regular expression logic. You enter the output names.
The mapping creates the outputs on the Parse transformation at run time. If you expect an input field to contain more than one value that matches the regular expression, create an output for each value. For example, you might add two outputs if you will use the step to find data values that occur in pairs, such as map coordinates.
ASK INFAPreview
