How to Split Product Dimensions into Length, Width, and Height

Task

One dimensions column contains values like 120 x 60 x 75 cm. A marketplace or catalog import needs separate length_cm, width_cm, and height_cm columns.

Short answer

Create three output columns and keep the needed number in each one with a regex. For width and height, remove the x separator and extra text after extraction.

How to Do It in Eofferix

1. Open the settings of the length_cm column.

   

2. For length_cm, add the regex [0-9]+(?:[,.][0-9]+)? with Remove everything except.

   

3. For width_cm, use [x×]\s*[0-9]+(?:[,.][0-9]+)?, then remove x and trim spaces.

   

4. For height_cm, use [x×]\s*[0-9]+(?:[,.][0-9]+)?\s*(?:cm)?$, then remove x, cm, and trim spaces.

   

5. Save the column settings and go to the Export step.

Before / After