How to split a category path into levels

2026-06-20

Task

The path column contains a value such as Clothing/Jackets/Winter. The export needs category_1, category_2, and category_3.

Short Answer

Create three final columns from path and keep the needed part with a regex rule in each one.

How to Do It in Eofferix

Open the category_1 column settings in the table editor.
The red frame shows where to open the required column settings.
For category_1, add regex ^[^/]+ with action Remove everything except.
The rule keeps the part before the first slash.
Use (?<=/)[^/]+(?=/) for category_2 and [^/]+$ for category_3.
Save the column settings.

source data

sku	path
SKU-1001	Clothing/Jackets/Winter

result

sku	category_1	category_2	category_3
SKU-1001	Clothing	Jackets	Winter