BEGIN { #usage: awk -f HT_doGPGGA.awk filename.txt #NOTE: change the JD in the printf statement printf("Latitude, Longitude, Hours, Minutes, Seconds, Julian_Day, Year, CruiseID\n") FS = "," } { FS = "," if ($1 =="$GPGGA") { hr = substr($2,1,2) min = substr($2,3,2) sec = substr($2,5,2) latdeg = substr($3,1,2) latmin = substr($3,3,9) londeg = substr($5,1,3) lonmin = substr($5,4,9) declat = latdeg + (latmin / 60) declon = -1 * (londeg + (lonmin / 60)) printf ("%9.6f, %10.6f, %s, %s, %s, 254, 2007, 07003\n",declat,declon,hr,min,sec) } }