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