Script RegEx Extract Transformation
Data flow transformation, extracting elements from specified input using regular expression. The groups specified in the regular expression are setup as output data flow columns and populated appropriately.
The script has the following parameters:
- MatchColumns - the input columns to use for regular expression searching matching.
- Pattern - the regular expression pattern to be used. Each group becomes a separate column in the output. Names of these columns match the names of the groups, if specified, or their index, otherwise.
- IgnoreCase - perform a case-insensitive matching.
- Multiline - make a per-line matching, i.e. treat
$per each line, as opposed to the whole input.
Ready to give it a try?
COZYROC SSIS+ Components Suite is free for testing in your development environment.