| Extraction Operator | Description | Note |
|---|---|---|
| Keep Field | Keep this field in the extracted data. | – |
| Equal (==) | Delete row if field value equals comparison value. |
Works for strings, integers, and dates1. |
| Not Equal (!=) | Delete row if field value does not equal comparison value. |
Works for strings, integers, and dates1. |
| Greater than (>) | Delete row if field value is greater than comparison value. |
Works for integers and dates1. Strings are skipped and row is kept in the data. |
| Smaller than (<) | Delete row if field value is smaller than comparison value. |
Works for integers and dates1. Strings are skipped and row is kept in the data. |
| Greater than or equal (>=) | Delete row if field value is greater than or equal to comparison value. |
Works for integers and dates1. Strings are skipped and row is kept in the data. |
| Smaller than or equal (<=) | Delete row if field value is smaller than or equal to comparison value. |
Works for integers and dates1. Strings are skipped and row is kept in the data. |
| Delete match (regex) | Remove the part of the field value that matches the regex. Example: regex ^Watched transforms "Watched video XY" → "video XY" |
Values are converted to strings before regex matching. |
| Replace match (regex) | Replace the matching part of the field value with replacement value.Example: regex [\w\-\.]+@([\w\-]+\.)+[\w\-]{2,4} with replacement _anonymized_ transforms "some text email@address.com" → "some text _anonymized_" |
Values are converted to strings before regex matching. |
| Delete row when match (regex) | Delete the entire row if the field value matches the regex. Example: regex ^Watched deletes any row where the field starts with "Watched " |
Values are converted to strings before regex matching. |
1Dates are detected if formatted as ISO, RFC2822, or HTTP, and only if both values use the same format. Otherwise, treated as strings.