How to split one column into multiple columns?

One Star

How to split one column into multiple columns?

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
One Star

Re: How to split one column into multiple columns?

Hi
Check tNormalize component
Seven Stars

Re: How to split one column into multiple columns?

Not tNormalize; use tExtractDelimitedFields
One Star

Re: How to split one column into multiple columns?

Hi
Thanks Alevy for correcting me

Re: How to split one column into multiple columns?

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 ?
Seventeen Stars

Re: How to split one column into multiple columns?

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?

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.
One Star

Re: How to split one column into multiple columns?

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...Smiley Sad
One Star

Re: How to split one column into multiple columns?

ok..i already got the answer for my problem..tq..Smiley Happy
One Star

Re: How to split one column into multiple columns?

hi yana_isma,

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

regards
One Star

Re: How to split one column into multiple columns?

 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
One Star

Re: How to split one column into multiple columns?

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

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

Re: How to split one column into multiple columns?

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

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