If a file has been successfully validated, the relevant information will be extracted according to extraction rules
which can be configured below.
These rules are applied to the uploaded data consecutively in the defined order. If no rules are configured, no data are extracted.
All the data extraction steps are executed on the participant's device in the browser using JavaScript.
To configure the data extraction, follow these steps:
extraction rule
with the "Keep field" operator.
When a file is uploaded, the configured rules are applied row-wise/entry-wise. This means, for every data row/entry in the uploaded data, the rules are applied in the configured order.
Available extraction operators
Extraction Operator | Description | Note |
---|---|---|
Keep Field | Keep this field in the uploaded data. | – |
Equal (==) | Delete row/entry if the value contained in the given field equals the comparison value . |
Works for strings, integers, and dates1. |
Not Equal != | Delete row/entry if the value contained in the given field does not equal the comparison value . |
Works for strings, integers, and dates1. |
Greater than (>) | Delete row/entry if the value contained in the given field is greater than the comparison value . |
Works for integers and dates1. String values are skipped and the row will be kept in the data. |
Smaller than (<) | Delete row/entry if the value contained in the given field is smaller than the comparison value . |
Works for integers and dates1. String values are skipped and the row will be kept in the data. |
Greater than or equal (>=) | Delete row/entry if the value contained in the given field is greater than or equal to the comparison value . |
Works for integers and dates1. String values are skipped and the row will be kept in the data. |
Smaller than or equal (<=) | Delete row/entry if the value contained in the given field is smaller than or equal to the comparison value . |
Works for integers and dates1. String values are skipped and the row will be kept in the data. |
Delete match (regex) | Delete parts of the value contained in the given field that match the given regular expression (regex)
(e.g., if the regular expression (regex) = "^Watched " and a field contains the value "Watched video XY" the following
value will be kept in the uploaded data: "video XY"). |
All field values are converted to strings before this operation is applied. |
Replace match (regex) | Replace parts of the value contained in the given field that match the given regular expression (regex)
(e.g., if the regular expression (regex) = "[\w-\.]+@([\w-]+\.)+[\w-]{2,4}" and
the replacement value = "_anonymized_" and a field contains the value "some text email@address.com" the following
value will be kept in the uploaded data: "some text _anonymized_"). |
All field values are converted to strings before this operation is applied. |
Delete row when match (regex) | Delete row/entry if the value contained in the given field matches the given regular expression (regex) (e.g., if
regular expression (regex) = "^Watched " and a field contains the value "Watched video XY"
the row/entry will be deleted from the uploaded data). |
All field values are converted to strings before this operation is applied. |
1Dates are inferred from string values if they are formatted according to ISO, RFC2822, or HTTP standards, and only if both the field value and the comparison value follow the same format. Otherwise, the entry will be treated as a regular string.