BEGIN{ } { date = $1 airtemp = $3 seatemp = $4 humid = $17 wspd = $18 wdir = $19 } END{ dday = int(date); if ( dday != day ){ printf("Days don't match\n"); } hour = ( date - day) * 24; hour -= offset; airtemp = ( airtemp * 1.8 ) + 32 seatemp = ( seatemp * 1.8 ) + 32 printf ( "%04.1f %.0f %.0f %.0f %03.0f \n",hour,airtemp,humid,wspd,wdir); }