/ ap_db-rearrange.awk
ap_db-rearrange.awk
1 BEGIN { 2 FS=OFS=","; 3 RS="\n"; 4 outfile = "ap_db.csv"; 5 } 6 7 NR !=1 { 8 !$1 and $1 !=0 {print "NULL"} 9 srand() $0; 10 } 11 12 print > outfile
1 BEGIN { 2 FS=OFS=","; 3 RS="\n"; 4 outfile = "ap_db.csv"; 5 } 6 7 NR !=1 { 8 !$1 and $1 !=0 {print "NULL"} 9 srand() $0; 10 } 11 12 print > outfile