Subject: Lab Test Log #1946 Date: Thu, 1 Jun 2000 10:56:15 -0500 (CDT) From: JUDY F To: HAMPSHIRE - KUR FAILED HV HRD. I'LL CONT. TEST @ SHERRY'S CLAY, UNLESS I HEAR FFM. YOU. THANKS JUDY ELP - HAMPSHIRE(21) 06-01-00 10:54:34 JUDY F TERM # 171 LAB TEST LOG - LAB #1946 PAGE # 1 -------------------------------------------------------------------------------- Date In 05-30-00 1:00pm In Initials JF Lab Test Type Final Tag # 116014 Customer In Comments RTR 10342 COIL B -------------------------------------------------------------------------------- Status Non-Conforming Date Out 06-01-00 10:52am Out Initials JF Lot Code H88231C Out Comments @.0075 T 102538 Y 39121 E 70% HRD.83 HRB (*159HV1KG)7RA B 3.48 DL .25 @ S.L.PER SUS. IGA /DOES NOT MEET WARD HV HRD. -------------------------------------------------------------------------------- ** ORDERS ** -------------------------------------------------------------------------------- 21 12136-1 COMBINED METALS OF CHICAGO #### #!/bin/perl $delimiter = ","; $i=0; while(<>) { chomp; if ($_ =~ /^Subject:/){ @subject[$i] = $_; @subject[$i] =~ s/^Subject:(\D+)(\d+)/$2/e; } ... ... (more if statements to select what I need) ... (the concatenating part between the words "Out Comments" and "----") if ($_ =~ /^Lot Code/){ @lotCode[$i] = $_; @lotCode[$i]=~ s/^Lot Code(\s+)(\w+)/$2/e; $i++; } open OUTPUT, ">>data.txt"; # $allvar=join(',', $tag,$lotCode); # $result=$allvar; } for ($j=0; $j < $i; $j++) { print OUTPUT "@subject[$j];@failed[$j];@monthi[$j]/@dayi[$j]/@yeari[$j];@routerval[$j];" . "@tag[$j];@montho[$j]/@dayo[$j]/@yearo[$j];@lotCode[$j];@commentso[$j]\n"; print "@subject[$j];@failed[$j];@monthi[$j]/@dayi[$j]/@yeari[$j];@routerval[$j];" . "@tag[$j];@montho[$j]/@dayo[$j]/@yearo[$j];@lotCode[$j];@commentso[$j]\n"; }