Versions Compared

Version Old Version 2 New Version 3
Changes made by

Former user

Former user

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

IMPORTANT: Don't panic!  For people new to regular expressions, the cryptic nature of the language can be a bit daunting.  However, "RegExps" pack a lot of punch and are very much worth your the time you spend on it.

Settings Tab

Option

Description

Step name

Name of the step.

Note: This name has to be unique in a single transformation.

Field to evaluate

Name of the field to evaluate

Result Fieldname

The name of the return field (boolean)

Create fields for capture groups

Enable this if you want to create new fields based on capture groups in the regular expression.

Regular expression

Put here the regular expression to match.

Use variable substitution

If you use variable, return it's content by selecting this option.

Capture group fields

Here you can specify the new fields you would like to capture.
IMPORTANT: The order of occurrence is the same as the order of the capture groups in the regular expression. The different columns allow you to change to the required data type right away.Note:  A capture group is a part of the expression between 2 brackets.  For example, you can capture a sequence of numerical characters like this: .([0-9]).*

...