help me!!! AWK

kinux

hi all,  

how to do so...

>>The script can be run as:
>>
>>awk -f mkcsv_m.awk mydatafile.dat > mydatafileo.dat
>>
>>There are 3 main functions delivered from your script:
>>1) produce a header line
>>2) convert date format from dd-mm-yyyy to dd/mm/yyyy
>>3) convert all field seperators "|" to ","


Mydatefile.dat


01-02-2003|15|12|10|8|3|9|57|
02-02-2003|12|15|9|3|8|10|57|
03-02-2003|2|5|9|3|8|0|57|
04-02-2003|3|9|3|8|0|57|5|
05-02-2003|4|5|9|3|8|0|57|
06-02-2003|5|3|8|0|57|5|9|
07-02-2003|6|5|9|3|8|0|57|
08-02-2003|7|5|9|3|8|0|57|
09-02-2003|3|8|0|57|8|5|9|
10-02-2003|9|5|139|3|8|0|57|
11-02-2003|10|5|9|3|8|0|57|




mydatafileo.dat

Transaction Date,Ctr1,Ctr2,Ctr3,Ctr4,Ctr5,Ctr6,Total,
01/02/2003,15,12,10,8,3,9,57,
02/02/2003,12,15,9,3,8,10,57,
03/02/2003,2,5,9,3,8,0,57,
04/02/2003,3,9,3,8,0,57,5,
05/02/2003,4,5,9,3,8,0,57,
06/02/2003,5,3,8,0,57,5,9,
07/02/2003,6,5,9,3,8,0,57,
08/02/2003,7,5,9,3,8,0,57,
09/02/2003,3,8,0,57,8,5,9,
10/02/2003,9,5,139,3,8,0,57,
11/02/2003,10,5,9,3,8,0,57,

didikei

BEGIN {
FS="|";
print "Transaction Date,Ctr1,Ctr2,Ctr3,Ctr4,Ctr5,Ctr6,Total,";
}
{
split($1,t,"-"; printf "%s/%s/%s",t[1],t[2],t[3]
for( i=2;i<=NF;i++) printf ","$i
printf "\n"
}

不过sed好象更简洁一点
s/|/,/g
s/-/\//g
1i\
Transaction Date,Ctr1,Ctr2,Ctr3,Ctr4,Ctr5,Ctr6,Total,

kinux

This is a homework of my friend, i know use sed will work perfectly..

But it use awk only...

thank you very much...

kinux

seems more something... at end with "//"

people:homework {119} awk -f new.awk test.dat > test1.dat
people:homework {120} cat test1.dat
Transaction Date,Ctr1,Ctr2,Ctr3,Ctr4,Ctr5,Ctr6,Total,
01/02/2003,15,12,10,8,3,9,57,
02/02/2003,12,15,9,3,8,10,57,
03/02/2003,2,5,9,3,8,0,57,
04/02/2003,3,9,3,8,0,57,5,
05/02/2003,4,5,9,3,8,0,57,
06/02/2003,5,3,8,0,57,5,9,
07/02/2003,6,5,9,3,8,0,57,
08/02/2003,7,5,9,3,8,0,57,
09/02/2003,3,8,0,57,8,5,9,
10/02/2003,9,5,139,3,8,0,57,
11/02/2003,10,5,9,3,8,0,57,
//

didikei

BEGIN {
FS="|";
print "Transaction Date,Ctr1,Ctr2,Ctr3,Ctr4,Ctr5,Ctr6,Total,";
}
/^[0-9]/{
split($1,t,"-"; printf "%s/%s/%s",t[1],t[2],t[3]
for( i=2;i<=NF;i++) printf ","$i
printf "\n"
}