Login / Sign up
Table editor

How to Extract Product Size from the Product Name

2026-06-20

Task

The product size is inside the name, for example Basic T-shirt XL black. The export needs a separate size column.

Short answer

Create size from name and keep only the size with \b(?:XS|S|M|L|XL|XXL|XXXL)\b|\b\d{2}\b.

How to Do It in Eofferix

  1. Open the settings of the output size column.
    Animation showing how to open the size column settings
    The click is on the settings icon of the size column.
  2. In Transformations, add a Regular expression rule with Remove everything except: \b(?:XS|S|M|L|XL|XXL|XXXL)\b|\b\d{2}\b.
    Screenshot of transformation rules for the size column
    The Transformations block shows the full rule chain for this case.
  3. Save the column settings and go to the Export step.

Before / After

Before

source data
skuname
SKU-300Basic T-shirt XL black
SKU-301Outdoor jacket 48 blue

After

result
skusize
SKU-300XL
SKU-30148

Process data faster with Eofferix

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

Sign up