Table editor
How to Capitalize the First Letter of a Product Description
Normalize product descriptions when supplier text starts lowercase or arrives fully uppercased.
Use cases — Page 5
Table editor
How to Convert Excel Product Names to Title Case
Normalize product name capitalization when supplier rows arrive uppercased or fully lowercase.
Table editor
How to Remove Rows Without SKU from a Supplier Price List
Remove supplier service rows without SKU so the final price list contains only real products.
Transformations
How to extract the text inside brackets and remove everything else
Keep the value inside brackets and remove the rest when a code or category is hidden in a text string.
XML
XML: how to normalize supplier price with spaces and comma
Two replace rules in the XML editor turn 1 200,50 into 1200.50 and exclude zero-price items.
JSON
How to rename JSON keys without changing values
If the receiving system expects different JSON key names, rename result nodes in the template and leave the values unchanged.
JSON to CSV
How to export only active JSON records to CSV
To keep disabled records out of CSV, add an export condition by the active flag and apply it to the whole record.
Format conversion
How to turn a JSON items array into CSV rows
Choose a JSON source and CSV output. Open the Items sheet, move it to the first position, save the template, then run the transformation.
Format conversion
How to flatten nested JSON into CSV columns
Choose a JSON source and CSV output. In the table snapshot, keep the original JSON paths as sources and rename only the final column headers.
Interpreter
How to extract a barcode from text with a regular expression
Keep the result as text: remove spaces and hyphens first, then use a barcode-length regex with Keep only matching text.
Interpreter
How to extract a SKU and remove extra characters with a regular expression
Use a regex that matches the real supplier SKU format, keep the match, and only then apply uppercase or other normalization.
Interpreter
How to extract a phone number from text with a regular expression
Find the number with a preset or custom regex, keep the match, then normalize spaces, brackets and hyphens for the CRM format.
Interpreter
How to Skip Products with Zero Price or Empty Stock
Normalize the price first, then place export conditions on the row or product element: price greater than 0, stock not empty.
Process data faster with Eofferix
Create a free account and use larger files, saved scenarios and team workflows.