Versions Compared

Key

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

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:

...