# Generate file with WG epoch time, lat, lon from telemetry file downloaded # through WGMS. BEGIN { FS=","; tzOffsetSec = 7 * 3600; } NR==1 { next; } { cmd = sprintf("ut2et -format '%%Y/%%m/%%d %%H:%%M %%Z' '%s'", $1); ## print "cmd: " cmd; cmd | getline et; close(cmd); et -= tzOffsetSec; printf("%d %.5f %.5f\n", et, $12, $13); }