I have added fields 3/4 together, and will add decimal seconds/milliseconds since start of log as a new field.
MalibuJack wrote:mad_viii wrote:for now you can awk columns 3 and 4 together to get hh:mm:ss.ssss format on the time.
gawk -F , -v OFS=, '{print $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}' EvoScanDataLog_2006.07.07_09.28.55.csv >>EvoScanDataLog_2006.07.07_09.28.55.fixed.csv
I'm sure there is an easier way than listing out each of the fields but this works.
