open(OUT, ">/Users/micwood/Desktop/output.csv"); my $novalue = '.'; # temp value my $temp = '.'; # temp value my $awardhashref= (); my $allDocs = do { local $/ = '<\/table>\n
\n
'; <>; }; my $rxExtractDoc = qr {(?xms) (

Award\s\#(\d+)<\/h4>(.*?)<\/table>\n
\n
) }; while ($allDocs =~ m{$rxExtractDoc}g ) { my %award = (); # award hash $award{'entireaward'}= $1; $award{'A_awardno'}= $2; $award{'entireaward'}=~ s/\n//g; $award{'entireaward'}=~ s/\t//g; $award{'entireaward'}=~ s/\r//g; if ($award{'entireaward'} =~ m{Dollars Obligated<\/td>\$([^<]+?)<\/font>}gi){ $award{'B_dollob'} = $1};