Login / Sign up
Table transformations

How to remove brand, SKU, and size from product names in a spreadsheet

2026-06-20
Task

The supplier file has name_raw, but the product name already contains the brand, SKU, and size. The output needs a clean clean_name column.

Short answer

Create clean_name from name_raw: remove {brand}, remove the SKU with a regular expression, remove {size}, then collapse spaces and trim the result.

How to do it in Eofferix

  1. Open the settings of the output clean_name column and use name_raw as its source.

    clean_name column settings in the Eofferix table editor
    The red outline marks the settings button for the clean_name column used in this case.

  2. In Transformations, add these rules: Contains substring → {brand} → Remove substring; Regular expression → SKU[- ]?[0-9]+ → Remove substring; Contains substring → {size} → Remove substring; then collapse spaces and trim edges.

    Rules that remove brand, SKU, and size from the product name
    This block shows the full transformation chain for clean_name.

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

Before / after

Before

source data
skubrandname_rawsize
SKU-100LumaLuma black desk lamp SKU-100 40 cm40 cm
SKU-200SeatProSeatPro gray office chair SKU-200 LL

After

result
skuclean_name
SKU-100black desk lamp
SKU-200gray office chair

Process data faster with Eofferix

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

Sign up