#awk -f script table2.viz > table2.viz2 { jd=substr($0,1,9) # acut -c1-9 h=substr($0,22,6) # acut -c22-27 printf("%.5f\n", jd+h/24) }