Fellow monks I come in seek of knowledge, again. Well everything was great until my Online Banking Website switched from QIF (Quicken) account information downloads to OFX / SGML files. Why can't people leave things well enough alone. I've searched for a editor/viewer for OFX / SGML files but haven't had any luck so I thought that I might be able to write a small script to get the needed information out of the file.
  Anyway my delima is that I don't know if I should use a module like XML::Simple or just throw together something else. Or maybe someone knows of a existing script I could use. Below is a sample of what the file looks like. Thanks in advance! 
OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:NONE
<OFX>
<SIGNONMSGSRSV1>
   <SONRS>
<readmore>
      <STATUS>
         <CODE>0
         <SEVERITY>INFO
      </STATUS>
      <DTSERVER>###########
      <LANGUAGE>ENG
      <FI>
         <ORG>S1
         <FID>########
      </FI>
      <INTU.BID>###
   </SONRS>
</SIGNONMSGSRSV1>
<BANKMSGSRSV1>
   <STMTTRNRS>
      <TRNUID>0
      <STATUS>
         <CODE>0
         <SEVERITY>INFO
      </STATUS>
      <STMTRS>
         <CURDEF>USD
         <BANKACCTFROM>
            <BANKID>########
            <ACCTID>DDA##-#########
            <ACCTTYPE>CHECKING
         </BANKACCTFROM>
         <BANKTRANLIST>
            <DTSTART>##########
            <DTEND>###########
            <STMTTRN>
               <TRNTYPE>POS
               <DTPOSTED>###########
               <TRNAMT>-106.00
               <FITID>#############
               <NAME>H &amp; R Block
            </STMTTRN>
            <STMTTRN>
               <TRNTYPE>POS
               <DTPOSTED>##########
               <TRNAMT>-3.19
               <FITID>#########
               <NAME>Chevron
            </STMTTRN>
         </BANKTRANLIST>
         <LEDGERBAL>
            <BALAMT>##.##
            <DTASOF>##############
         </LEDGERBAL>
      </STMTRS>
   </STMTTRNRS>
</BANKMSGSRSV1>
</OFX>

[download]
   --JD

In reply to OFX/SGML Parse by draper7

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.