Hi,
i have a csv like below:

USA
1 newyork
2 wasington
UK
1 London
2 Manchester
Japan
1 Tokyo

i need to format it like this:
1 USA Newyork
2 USA wasington
3 UK LONDOn
4 UK Manchester
5 Japan Tokyo

preferable lang shell script. can anyone please help me.............

Well I am not seeing many c's in the csv, but that aside, what have you done so far to solve the problem?

1 members found this post helpful.

With this InFile ...
... this awk ...
... produced this OutFile ...
Daniel B. Martin

thanks daniel. can you please help me to remove trailing "," from the line like below:

2013-10-13 06:00:00, USA, NEWYORK,123,,,,,,,,,,,,

Try this ...
Daniel B. Martin

thanks again daniel. i have used "sed -i -e 's/,*$//' OutFile" but didnt got any changes

Well, as grail asked you: can you show us what YOU have done/tried to solve this?? Can you not experiment and think about the solutions/tools given to you so far, to find the solution on your own?

That's the point of homework, isn't it?

Take a close look at your code. The sed needs some kind of input to chew on. Where did you give it the input?

Daniel B. Martin

Dear TB0ne,
i am trying to develop a script to format a csv file (cu.csv) and load into database. my file look like below

cu.csv
(group--121 XYZ) ,,,,,,,,,,,,,,,,,,,,,,,,,
2013-09-12 01:00:00+06:00,9.95,20.61,463,2.15,4.45,6.60,1,15,,,,,,,,,,,,,,,,,
2013-09-12 02:00:00+06:00,5.1,13.09,463,1.10,2.83,3.93,1,15,,,,,,,,,,,,,,,,,
2013-09-12 03:00:00+06:00,2.36,7.88,463,0.51,1.70,2.21,0,15,,,,,,,,,,,,,,,,,
2013-09-12 04:00:00+06:00,1.65,6.21,463,0.36,1.34,1.70,0,15,,,,,,,,,,,,,,,,,

i need the output (NFILE) like

NFILE
2013-09-12 01:00:00 121 9.95 20.61 463 2.15 4.45 6.60 1 15
2013-09-12 02:00:00 121 5.1 13.09 463 1.10 2.83 3.93 1 15

I have used below code to format the output

awk '{if ($1!~/[0-9]/) c=$2; else {$1=$1","c","; print $0}}' cu.csv >OutFile
sed -i -e 's/group--//g' OutFile
sed -i -e 's/ //g' OutFile
sed -i -e 's/+06:00//g' OutFile

after all this till now i got

(OutFile)
2013-09-12,121,01:00:00,9.95,20.61,463,2.15,4.45,6.60,1,15,,,,,,,,,,,,,,,,,
2013-09-12,121,02:00:00,5.1,13.09,463,1.10,2.83,3.93,1,15,,,,,,,,,,,,,,,,,
2013-09-12,121,03:00:00,2.36,7.88,463,0.51,1.70,2.21,0,15,,,,,,,,,,,,,,,,,
2013-09-12,121,04:00:00,1.65,6.21,463,0.36,1.34,1.70,0,15,,,,,,,,,,,,,,,,,

i need to remove the "," and re-arrange the fields. i tried below code but 1st row remains same

awk '{FS=",";print $1"\t"$3"\t"$2"\t"$4"\t"$5"\t"$6"\t"$7"\t"$8"\t"$9"\t"$10"\t"$11"\t"$12;}' OutFile >NFile

(NFile)
2013-09-12,121,01:00:00,9.95,20.61,463,2.15,4.45,6.60,1,15,,,,,,,,,,,,,,,,,
2013-09-12 02:00:00 121 5.1 13.09 463 1.10 2.83 3.93 1 15
2013-09-12 03:00:00 121 2.36 7.88 463 0.51 1.70 2.21 0 15
2013-09-12 04:00:00 121 1.65 6.21 463 0.36 1.34 1.70 0 15

can you tell me , where i missed something?

---------- Post added 10-15-13 at 12:56 AM ----------

Martin
Outfile is the input file. i tried to modify that.

Starting with InFile2 ...
... this code ...
... changed InFile2 to this ...
This code snippet assumes you have the files InFile2 and the script itself in the same folder.

Daniel B. Martin

if you don't mind trailing tabs

if you don't want the trailing tabs

thanks Firerat and martin. my problem solved.