topic Re: How to split one column into multiple columns? in Talend Studio

How to split one column into multiple columns?

Anonymous — Sat, 16 Nov 2024 12:54:17 GMT

Hi,
I want to split a column into 3 columns, i am getting the data from a tab delimited file which will have a column called "name", the format of which will be
"LastName,FirstName MiddleName"
I want to split this into 3 colums,
LastName FirstName MiddleName
Could you guys tell me how can this be done?
Thanks
Aviral

Re: How to split one column into multiple columns?

Anonymous — Wed, 25 May 2011 08:56:49 GMT

Hi
Check tNormalize component

Re: How to split one column into multiple columns?

alevy — Fri, 03 Jun 2011 02:40:06 GMT

Not tNormalize; use tExtractDelimitedFields

Re: How to split one column into multiple columns?

Anonymous — Fri, 03 Jun 2011 07:09:04 GMT

Hi
Thanks Alevy for correcting me

Re: How to split one column into multiple columns?

Anonymous — Fri, 08 Nov 2013 08:01:05 GMT

I have a column like
Cincinnati ,Ohio,USA
kabul,Afghanistan

i need to split it like city | state | country
for the first row it works fine with Extract Delimited
but for the second row country falling in state
Please help me ?

Re: How to split one column into multiple columns?

Anonymous — Fri, 08 Nov 2013 10:35:02 GMT

Please take a look to the component tExtractRegexFields. With this component and a good REGEX knowledge you can extract nearly everything.

Re: How to split one column into multiple columns?

Anonymous — Wed, 26 Mar 2014 09:53:21 GMT

tExtractDelimitedFields is best suitable if column contains specific delimiter.
I have used this component to split single column value to multiple columns and also there is no side effect to other columns.

Re: How to split one column into multiple columns?

Anonymous — Wed, 07 Jan 2015 02:59:44 GMT

sori for interrupted..
i have a problem where i have 1 column consists the data like this..
|1.2.3.4.5|
i want to split the data into 5 column and the output become to:
|1| |2| |3| |4| |5|
anyone can help me...

Re: How to split one column into multiple columns?

Anonymous — Wed, 07 Jan 2015 03:25:12 GMT

ok..i already got the answer for my problem..tq..

Re: How to split one column into multiple columns?

Anonymous — Fri, 23 Oct 2015 15:26:49 GMT

hi yana_isma,

i'm facing the same issue, can you tell how did you do plz ?

regards

Re: How to split one column into multiple columns?

Anonymous — Wed, 04 Nov 2015 10:06:26 GMT

hi, I have source like
ID,NAME
1&2,A&B
3/4,C/D
5&6,E/F
In my target the data would be like
ID,NAME
1,A
2,B
3,C
4,D
5,E
6,F
How can i achieve this can any one help me

Re: How to split one column into multiple columns?

Anonymous — Fri, 11 Dec 2015 15:27:59 GMT

ok..i already got the answer for my problem..tq..

hey Yana can you please tell me how you rectified the problem...
I am also facing the same issue...:-(

Re: How to split one column into multiple columns?

_AnonymousUser — Tue, 02 Feb 2016 06:22:15 GMT

ok..i already got the answer for my problem..tq..

Hi Yana_isma,
Can you please tell me how you resolved your problem ?