If you are starting with .prn files, then I assume (heh) that you are dealing with page images in a monospace font.

If that's fair, then you are most likely dealing with some kind of fixed format -- a couple lines of page header, same thing for the footer, and in the middle (the rest) is all of the good stuff, in columns.

Unless the columns are wrapped (I handled that for my first Perl contract -- it was fun, back in 1998), it's simple to split the columns up, perhaps using a regular expression with fixed width groups.

So, some pseudo-code to handle the .prn file would be something like this:

Once that's done, you can use Spreadsheet::WriteExcel to write it out to an Excel spreadsheet. Alternatively, try Text::CSV just to make a CSV out of it -- sometimes it's better to take small steps.

So, come back and let us know how it all worked out.

Alex / talexb / Toronto

"Groklaw is the open-source mentality applied to legal research" ~ Linus Torvalds

In reply to Re: Converting txt Reports (.prn file) in Excel with Perl by talexb
in thread Converting txt Reports (.prn file) in Excel with Perl by admiraln

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.