>

GPS Data Conversion

# cat * | grep ^T > Total.txt
# cat Total.txt | sed 's/T  //' > Tstriped.txt
# grep -v '^Tr' Tstriped.txt > Total.txt
# cat Total.txt | sed -e 's/ 1999//' -e 's/ Sun//' -e 's/ Mon//' -e 's/ Tue//' -e 's/ Wed//' -e 's/ Thu//' -e 's/ Fri//' -e 's/ Sat//' > Finished.txt
# cat Finished.txt | sed -e 's/^\(.\{12\}\)/\1,/' -e 's/^\(.\{26\}\)/\1,/' -e 's/ ,/,/g' > Final.csv
  1. Extract Only Track Info
  2. Remove Track Label
  3. Remove Beginning and End lines
  4. Get rid of Days and Year
  5. Add Commas
banner ad

Comments are closed.