*****DNT (incorrect timing)***** Final format: AccX AccY AccZ MagX MagY MagZ D0 D1 D2 D3 # cat Recovery_DNT.txt | grep -a '^A X: ..... Y: ..... Z: ..... M X: ..... Y: ..... Z: ..... D0: ..... D1: ..... D2: ..... D3: ..... .... #' | grep -av 'GPGGA' > ParsedDNT.txt Manually delete some lines with bad characters.* cat ParsedDNT.txt | awk -F 'A ' '{print $2}' | awk -F 'X:' '{print $1,$2,$3}' | awk -F 'Y:' '{print $1,$2,$3}' | awk -F 'Z:' '{print $1,$2,$3}' | awk -F ' M ' '{print $1,$2}' | awk -F 'D0:' '{print $1,$2}' | awk -F 'D1:' '{print $1,$2}' | awk -F 'D2:' '{print $1,$2}' | awk -F 'D3:' '{print $1,$2}' | awk -F '#' '{print $1}' > DNT.txt Delete first line. *****DNT (correct timing)***** Final format: time AccX AccY AccZ MagX MagY MagZ D0 D1 D2 D3 # cat Recovery_DNT.txt | grep -a '^A X: ..... Y: ..... Z: ..... M X: ..... Y: ..... Z: ..... D0: ..... D1: ..... D2: ..... D3: ..... .... #\|$GPGGA,.......000,0000.00000,N,00000.00000,E,0,00,99.0,082.00,M,18.0,M,, #' | awk '{ if (length($0) < 107 && length($0) > 73) print $0}' > ParsedDNT2.txt Manually delete some lines with bad characters.* Edit ParsedDNT2.txt with vim and run the command, :%s/,, #\nA / /g Optional: cat ParsedDNTA.txt ParsedDNTB.txt | sort | uniq > CombinedDNT.txt (use 'sort | wc' and 'sort | uniq | wc' to make sure it's actually identifying duplicates because a trivial character difference (eg. an extra space) will confuse uniq) cat ParsedDNT2.txt | awk '{ if (length($0) > 106) print $0}' | awk -F ',' '{print $2,$13}' | awk -F 'D0:' '{print $1,$2}' | awk -F 'D1:' '{print $1,$2}' | awk -F 'D2:' '{print $1,$2}' | awk -F 'D3:' '{print $1, $2}' | tr 'XYZM:#' ' ' > DNT2.txt *****HAM***** Final format: hh mm ss (deg sec.sec/100 N) (deg sec.sec/100 W) Alt Temp cat Recovery_HAM.txt | sed 's/Good/\ /g' | sed 's/./\ /29' | grep -a 'W./A' | sed 's/./& /35' > ParsedHAM.txt Optional cat ParsedHAMA.txt ParsedHAMB.txt | sort | uniq > CombinedHAM.txt cat ParsedHAM.txt | tr '/' ' ' | tr 'A=' ' ' | tr 'C' ' ' | tr 'h' ' ' | tr 'WO' ' ' | tr 'N' ' ' |sed 's/./& /2' | sed 's/./& /5' > HAM.txt Delete first line. *Notes: When manually removing bad characters, first 'less' the file and scroll through it. Unknown character will be highlighted. Then go to the offending lines you have identified in vim and 'dd' them. 'cat file_name | grep -va [print]' may also help