Question regarding extraction of last strings in a row

Hello,

I need some help with my issue;

I am using the following format for categories;

ŽENSKE > Telo > Losjon za telo
ŽENSKE > Telo > Losjon za telo
ŽENSKE > Telo > Izdelki za prhanje > Gel za prhanje
ŽENSKE > Telo > Izdelki za prhanje > Gel za prhanje

Is there a way that I extract the strings after the last “>” to the new column.

For example;

Losjon za telo

Losjon za telo

Gel za prhanje

Gel za prhanje

Thanks,

There is probably more than one way to do this. The simplest one I can think of uses ‘split col’ and ‘fill’. Please see attached.

categories.transform (2.3 KB)

I think that the shortest way is to use the Replace transform using Regex mode substituting ".* > " with “” (without the quotes). This assumes that there is an extra space after the > sign that needs to be deleted.categories-2.transform (2.7 KB)

1 Like

Yes, that is even better. Thanks. ;0)