Posted by The TechMentor in Journal
on May 23rd, 2014 | Comments Off on 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
- Extract Only Track Info
- Remove Track Label
- Remove Beginning and End lines
- Get rid of Days and Year
- Add Commas