Script RegEx Match Transformation

Overview

Data flow transformation, directing all input rows to either Match or No match outputs, based on matching with a specified regular expression.

Setup

The script has the following parameters:

• MatchColumns - the input columns to use for regular expression searching. Finding a match in any of the columns sends the row to Match output.
• Pattern - the regular expression pattern to be used.
• IgnoreCase - perform a case-insensitive matching.
• Multiline - make a per-line matching, i.e. treat ^ and $ per each line, as opposed to the whole input.