rearranging columns

sureshbup · 11-01-2006, 11:45 AM

Hi to all.

I am new to linux. I have a csv file like this

"21","Ramesh","5","aiubghed"
"21","Ramesh","4","ghed"
"21","Ramesh","0","aiubaiub"
"21","Suresh","5","aghedghed"
"19","Suresh","A","aigheded"
"19","Suresh","A7","aiughedhed"

i need the output like this

Ramesh , suresh
aiubghed , aghedghed
ghed , aigheded
aiubaiub , aiughedhed

Is it possible to do it in awk or sed. Could anyone can help me . I am new to linux.

regards
ramesh

druuna · 11-01-2006, 11:57 AM

Sorry, I misunderstood the question.

Please ignore.

unSpawn · 11-01-2006, 12:29 PM

If this is supposed to be your homework please read the LQ Rules about asking homework questions.

nadroj · 11-01-2006, 12:48 PM

look into the cut and paste bash commands