How to split one column into multiple columns?

[Anonymous]

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

[Anonymous]

Hi
Check tNormalize component

[alevy]

Not tNormalize; use tExtractDelimitedFields

[Anonymous]

Hi
Thanks Alevy for correcting me

[Anonymous]

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 ?

[Anonymous]

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

[Anonymous]

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.

[Anonymous]

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

[Anonymous]

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

[Anonymous]

hi yana_isma,

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

regards