ignore certain parts of category

Submitted by atman on Sun, 2008-10-05 15:58 in Price Tapestry

hi,

i have a datafeed with a category structure like

Dogs -> Health and Safety -> Eye and Ear Care

i want to use only the

Eye and Ear Care

as category and ignore everything before that.

is it possible to make a filter to automatically do that?

thanks in advance.

Hello atman, Sure, this has

Submitted by support on Mon, 2008-10-06 08:25

Hello atman,

Sure, this has come up quite often (I think some Commission Junction feeds have categories like this). You want the "Explode" filter - the code is in this thread:

http://www.pricetapestry.com/node/2017

Then, add a new "Explode" filter to the category field, use an "Explode Character or String" value of "->" (without the quotes), and a Return Index value of -1 to return the last one!

Cheers,
David.

hi david, thanks for the

Submitted by atman on Thu, 2008-10-16 07:24

hi david,

thanks for the help on this.

is it also possible to detect this -> character and explode the category and use only the last variable automatically during the initial import?

thanks.
atman

Hi atman, That is exactly

Submitted by support on Thu, 2008-10-16 07:51

Hi atman,

That is exactly what using the Explode filter in this instance should do - it is only applied during the initial import. If that means there's another problem let me know and I'll look into that for you...

Cheers,
David.