would this layout would be an easier an approach to parse
Maybe, depends on what pages 2 and 3 are like. Are you parsing many reports all formatted the same ?. Or is the 3 pages just a small sample of the real report.
#!perl
use strict;
use Data::Dumper;
my $infile = 'report1.txt';
# date address description
my $fmt = "A16 A38 A*";
my @data = ();
my $recno = -1;
my $flag = 0;
open IN,'<',$infile or die "$infile $!";
while (<IN>){
chomp;
next unless /\S/;
$flag = 0 if /Page \d of \d/;
my ($date,$addr,$desc) = unpack $fmt,$_;
if ( $date =~ /\d\d.\d\d.20\d\d/ ){
$flag = 1;
++$recno;
$data[$recno] = [ $date,$addr,$desc ];
} elsif ($flag) {
$data[$recno][1] .= ' '.$addr if $addr;
$data[$recno][2] .= ' '.$desc if $desc;
}
}
close IN;
print scalar(@data)." records read\n";
print Dumper \@data;
poj
-
Are you posting in the right place? Check out Where do I post X? to know for sure.
-
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big>
<blockquote> <br /> <dd>
<dl> <dt> <em> <font>
<h1> <h2> <h3> <h4>
<h5> <h6> <hr /> <i>
<li> <nbsp> <ol> <p>
<small> <strike> <strong>
<sub> <sup> <table>
<td> <th> <tr> <tt>
<u> <ul>
-
Snippets of code should be wrapped in
<code> tags not
<pre> tags. In fact, <pre>
tags should generally be avoided. If they must
be used, extreme care should be
taken to ensure that their contents do not
have long lines (<70 chars), in order to prevent
horizontal scrolling (and possible janitor
intervention).
-
Want more info? How to link
or How to display code and escape characters
are good places to start.
|