I used MS Access query to transform the 1st block of data below so it looks like the second block of data.
Is there any whay to do this using AWK or shell script?
808,634380820948829889,10/4/2011 01:28:15,"192.168.0.9",1,0
809,634380820950038523,10/4/2011 01:28:15,"192.168.0.9",0,0
810,634380829060872853,11/4/2011 01:41:46,"192.168.0.9",0,1
811,634380829062172319,11/4/2011 01:41:46,"192.168.0.9",1,1
I am trying to alter the above data so it reads similar to this:
2011,04,10,rx,01,28,15,pv,1,0
2011,04,10,rx,01,28,15,pv,0,0
2011,04,10,rx,01,41,46,pv,0,1
2011,04,10,rx,01,41,46,pv,1,1
thanks