Parse text file - regex or something else?
Posted on 2006-03-25
Hello! I have a text file I would like to parse, this data I plan to insert into a database.
Here is some sample data
<NAME>PUBLIX 11109 WINTHROP M
<MEMO>12/24 RIVERVIEW FL 8010I441922
1. Loop through text and locatate the <STMTTRN> </STMTTRN> blocks
2. extract out data and set variables TRNTYPE = POS, DTPOSTED = 20051227170000
Then I can insert into the db