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
This entry was posted in Journal. Bookmark the permalink.