Task
barcode contains valid codes and invalid values such as ABC-123. The export should keep only rows with numeric EAN/UPC-like codes.
Short answer
In barcode, add a row export condition: before transformations, the value must match ^(?=........$|............$|.............$|..............$)[0-9]+$.
How to do it in Eofferix
Open the settings of the
barcodecolumn.
The outline marks the column used to filter the row. In
Export conditions, add a row condition: scopeBefore transformations, conditionRegular expression, value^(?=........$|............$|.............$|..............$)[0-9]+$. This checks length 8, 12, 13, or 14 without curly braces, which Eofferix uses for field tokens.
Rows where barcodedoes not match the expression are excluded from the result.Save the template and run the transformation on the final step.
Before / after
Before
source data| sku | barcode | name |
|---|---|---|
| SKU-100 | 4601234567890 | Desk lamp |
| SKU-200 | ABC-123 | Office chair |
| SKU-300 | 12345678 | Folding chair |
After
result| sku | barcode | name |
|---|---|---|
| SKU-100 | 4601234567890 | Desk lamp |
| SKU-300 | 12345678 | Folding chair |