I have Apsona and easy populate. I always used easy populate but still had a bunch to do and is very timeconsuming.

My question is, when I get my suppliers datafeed the categorieare written like: "https://mysupplier.com/boom/category | subcat | subcat2 and so on.

In easy populate I need the categories in a seperate table category-cat2-cat3

Is there an eas way of doing this on the downloade datafeed besides going back one by oneand changing the whole spreadsheet??