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

[Anonymous]

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

[_AnonymousUser]

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

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