Login / Sign up
Table transformations

How to extract color and material from product specifications into columns

2026-06-20
Task

specs contains text such as Color: black; Material: metal; Size: M. The export needs separate color and material columns.

Short answer

Create two columns from specs: in color, keep the Color: ... fragment, remove Color:, and trim; repeat the same for Material: in material.

How to do it in Eofferix

  1. Open the settings of the output color column and use specs as the source.

    color column settings in Eofferix
    The outline marks the settings for color.

  2. For color, add: Regular expression → Color:\s*[^;]+ → Remove everything except; then Contains substring → Color: → Remove substring; then trim edges.

    Rules for extracting color from specs
    The first rule keeps only the color fragment; the second removes the Color: label.

  3. Create material from the same specs field and use the same pattern with Material:\s*[^;]+, remove Material:, then trim.

    Rules for extracting material from specs
    The material column uses the same logic with the Material: label.

  4. Save the template and run the transformation on the final step.

Before / after

Before

source data
skuspecs
SKU-100Color: black; Material: metal; Size: M
SKU-200Color: gray; Material: fabric; Size: L

After

result
skucolormaterial
SKU-100blackmetal
SKU-200grayfabric

Process data faster with Eofferix

Create a free account to automate catalogs and price lists around your own rules.

Sign up