Programming Forums - View Single Post

rasha · May 11th, 2005, 11:07 AM

I have managed to solve the problem

awk -F"|" '{if ($2 !~"\"\"" )  {print $0; X=$1 "|" $2 "|" $3 "|" $4 "|" $5 "|" $6 "|" $7 "|" $8 "|" $9 "|" $10 "|" $11 "|" $12 "|" $13 "|" $14 "|" $15 "|" $16 "|" $17 "|" $18 "|" $19 "|" $20 "|" $21 "|" $22 "|" $23 "|" $24 "|" $25 "|" $26 "|" $27 "|" $28 "|" $29 "|" $30 "|" $31 "|" $32 "|" $33 "|" $34 "|" $35 "|" $36 "|" $37 "|" $38 "|" $39 "|" $40 "|" $41 } else {print X "|" $42 "|" $43}}' inputfile.txt > outputfile.txt

May 11th, 2005, 11:07 AM	#2
rasha Newbie Join Date: May 2005 Posts: 2 Rep Power: 0	I have manged to solve the problem with following program I have managed to solve the problem (Toggle Plain Text) awk -F"\|" '{if ($2 !~"\"\"" ) {print $0; X=$1 "\|" $2 "\|" $3 "\|" $4 "\|" $5 "\|" $6 "\|" $7 "\|" $8 "\|" $9 "\|" $10 "\|" $11 "\|" $12 "\|" $13 "\|" $14 "\|" $15 "\|" $16 "\|" $17 "\|" $18 "\|" $19 "\|" $20 "\|" $21 "\|" $22 "\|" $23 "\|" $24 "\|" $25 "\|" $26 "\|" $27 "\|" $28 "\|" $29 "\|" $30 "\|" $31 "\|" $32 "\|" $33 "\|" $34 "\|" $35 "\|" $36 "\|" $37 "\|" $38 "\|" $39 "\|" $40 "\|" $41 } else {print X "\|" $42 "\|" $43}}' inputfile.txt > outputfile.txt awk -F"\|" '{if ($2 !~"\"\"" ) {print $0; X=$1 "\|" $2 "\|" $3 "\|" $4 "\|" $5 "\|" $6 "\|" $7 "\|" $8 "\|" $9 "\|" $10 "\|" $11 "\|" $12 "\|" $13 "\|" $14 "\|" $15 "\|" $16 "\|" $17 "\|" $18 "\|" $19 "\|" $20 "\|" $21 "\|" $22 "\|" $23 "\|" $24 "\|" $25 "\|" $26 "\|" $27 "\|" $28 "\|" $29 "\|" $30 "\|" $31 "\|" $32 "\|" $33 "\|" $34 "\|" $35 "\|" $36 "\|" $37 "\|" $38 "\|" $39 "\|" $40 "\|" $41 } else {print X "\|" $42 "\|" $43}}' inputfile.txt > outputfile.txt Last edited by rasha; May 11th, 2005 at 11:14 AM.