Split the column value into multiple columns

[McJingles]

I want to split the column of data into multiple columns.

Check the data below that is in my file.

Home & Garden

Apparel & Accessories > Shoes

pparel & Accessories > Clothing > Shirts & Tops

Apparel & Accessories > Clothing > Underwear & Socks > Lingerie

Please let me know any tricks to convert into multiple columns

Thanks in Advance

[Anonymous]

Hi,

you can use a tExtractDelimitedFields component to solve your problem.

But you have to be sure of the maximum column you can get from your original field.

Set the field separator to the value : ">" 

dont forget to trim your data

[McJingles]

Thanks for your reply @tehLurdUfEngmer 

But, I don't know how many delimiters are appear. By your saying, we need to insert exact columns.

If I don't know about the delimiters how can I split up those.?

[Anonymous]

You can't, or use a custom java routine that can give you the delimiter.