Subject:help converting a text file to xml Author:Alan Lapworth Date:21 Sep 2007 06:08 AM
I'm trying to convert a variable length file into XML. The problem is that each line consists of 3 different types of record:
1. record details.
2. header record.
3. detail record.
Just to confirm, all three of the above appear on the same line.
The record details are fixed width while the other two parts contain variable length data.
I can use regions ok if the file we receive is a single line but not when multiple lines exist (line 2+ of the file just appears as data in region 3). The detail record is terminated with the code "** **" but at the moment I cannot confirm if we will receive the data with a CRLF after each group of 3 records.