UNIX for Dummies Questions & Answers

Hi,

I need to devide one file into 3 files based on column numbers and put a string (FILE1, FILE2, FILE3) in the last.....

Input file:
Column1,Column2,Column3,Column4,Column5,Column6,Column7,Column8,Column9,Column10

Output1:
Column1,Column3,Column6,Column4,Column5,FILE1

Output2:
Column3,Column8,Column9,Column1,Column2,FILE2

Output3:
Column1,Column8,Column5,Column6,Column7,FILE3

Thanks.

Code:

awk '{
	print $1,$3,$6,$4,$5,"FILE1" > "output1.file"
	print $3,$8,$9,$1,$2,"FILE2" > "output2.file"
	print $1,$8,$5,$6,$7,"FILE3" > "output3.file"
	}' inputfile

Thanks for your reply but it gives syntax error....also if I run only for one file I get problems if some column has % symbol (column 10 has it).....example:

Input file:
0104100400,C,41.26,43.33,45.39,04/APR/2009,2009,02,MAR,LPF 3: % YTD(Main Exchange),03/APR/2010

Output1 should be (say column 2,10,3,6):

C,LPF 3: % YTD(Main Exchange),41.26,04/APR/2009,FILE1

Output2 should be (say column 2,10,4,11):

C,LPF 3: % YTD(Main Exchange),43.33,03/APR/2010,FILE2

I have tried cut, paste options but that is not what I want to use....If I use the following command
awk '{print $1,$3,$6,$4,$5,"FILE1" > "output1.file"}' inputfile I don't get the desired results.....

Input file:

0104100400,C,41.26,43.33,45.39,04/APR/2009,2009,02,MAR,LPF 3: % YTD(Main Exchange),03/APR/2010

Output (desired):
0104100400,41.26,04/APR/2009,43.33,45.39,FILE1


Output (actual with this awk command):
0104100400,C,41.26,43.33,45.39,04/APR/2009,2009,02,MAR,LPF % YTD(Main Exchange),03/APR/2010 FILE1

Reset the default field separators:

Code:

awk 'BEGIN{FS=OFS=","}{..}' file

I do not see any pattern on what criteria you should select the fields. Can you explain?

But for this one , you should use the field delimeter as , otherwise it is taking the space.

Code:

awk '{print $1,$3,$6,$4,$5,"FILE1" >> "outfile.txt}' OFS=","

cheers,
Devaraj Takhellambam

Thanks Devaraj and Franklin,

I will use the following:

awk 'BEGIN{FS=OFS=","}{print $1,$3,$10,$5,"FILE1"}' Input.txt >> output.txt