|
|
 next
|
  Subject: Convert flat file with varying record formats
Author: Jay Lessik
Date: 08 Dec 2005 11:01 AM
|
Hi,
I have Stylus Studio Enterprise 2006 and can't figure out how to accomplish this. Basically, I want to define a format based on the content of some data within each record. The records can be in any order, and the data that I'm testing to determine the record type is located in different areas within each type of record. It's kind of like a multi-pass conversion.
1. Check the record ID, if it's 1, then parse with 1 format, if it's 2 then parse with 2 format, etc.
2. Once parsed in record 2 format, then check if it's type A of record 2, and if so then parse remaining data using format 2A. If it's type B of record 2, then parse remaining data using format 2B, etc.
And the checks for the A and B, etc. types involve extracting data from different parts of the record and checking against constants, etc.
Can this be done easily in Stylus Studio? I fiddled around with the flat file conversion stuff and couldn't see a way to accomplish this.
Thanks!
|
|
|
|
top