http://www.perlmonks.org?node_id=1018441


in reply to Win32::OLE and Excel Question/Help

mmittiga17:

Perhaps something like:

my $buffer; while (my $line = <$INFH>) { $line =~ s/\n$//; if ($line =~ /^CUSIP/) { print $OUTFH $buffer, "\n" if defined $buffer; $buffer = $line; } else { $buffer .= $line; } }

...roboticus

When your only tool is a hammer, all problems look like your thumb.