Regex Multi Row Splitter

Splits rows according to groupings based on a regex pattern.

Up to 10 patterns can be specified, resulting in the first 10 ports containing rows which match the patterns.

If a row matches more than one pattern, it will be output on all matching ports if "Cascade Filtering" is OFF, but will only appear on the first matching port if "Cascade Filtering" is ON.

If fewer than 10 regex patterns are specified, not all 10 output ports will be populated.

If greater than 10 regex patterns are specified, only the first 10 will be used. The remainder will be ignored

The final output port provides a "catch-all". this returns all rows not caught by filtering.

Information about mappings, and row counts for each filter is available on the component's interactive view.

Thanks to @iCFO for ideas, feedback and encouragement! :-)

@takbb Brian Bates 16 Aug 2023

Update 17 Aug 2023 - Cascade Filtering added. Rewrite of filter processing to use either parallel Row Filters or chained Row Splitter depending on cascade filtering option.

Update 18 Aug 2023
Cascade filtering set to ON by default
Addition of "Interactive Table view" for feedback on mappings
Port 11 "mapping" has been moved Interactive View and to optionally created flow-variable.
Port 11 is now a hard-coded "catch all"

Renamed as "Regex Multi Row Splitter"

Input ports

1. Type: Table
   Input table
   Data to be filtered / split

Output ports

1. Type: Table
   Filter port 0
   Split / Filtered Rows
2. Type: Table
   Filter port 1
   Split / Filtered Rows
3. Type: Table
   Filter port 2
   Split / Filtered Rows
4. Type: Table
   Filter port 3
   Split / Filtered Rows
5. Type: Table
   Filter port 4
   Split / Filtered Rows
6. Type: Table
   Filter port 5
   Split / Filtered Rows
7. Type: Table
   Filter port 6
   Split / Filtered Rows
8. Type: Table
   Filter port 7
   Split / Filtered Rows
9. Type: Table
   Filter port 8
   Split / Filtered Rows
10. Type: Table
    Filter port 9
    Split / Filtered Rows
11. Type: Table
    Uncaught Rows
    Rows not previously caught by any filters.