topic Re: Split the column value into multiple columns in Talend Studio

Split the column value into multiple columns

McJingles — Fri, 07 Feb 2020 11:53:22 GMT

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 — Fri, 07 Feb 2020 14:09:24 GMT

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 — Mon, 10 Feb 2020 05:05:34 GMT

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 — Mon, 10 Feb 2020 06:53:27 GMT

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