The FILTER-ROW-IF-MATCHED directive filters records that match a pattern for a column.
Syntax
Code Block |
---|
filter-row-if-matched <column> <regex> |
The <regex>
is a valid regular expression that is evaluated on the column value for every record.
Usage Notes
The FILTER-ROW-IF-MATCHED directive applies the regular expression on a column value for every record. If the regex matches the column value, the record is omitted, otherwise it is passed as-is to the input of the next directive.
If the regex is null
, the value is compared against all the null
as well as JSON null values.
Examples
Using this record as an example:
...