Complex Flat File - Multiple Record Types (Records ID)
Posted: Fri Jun 18, 2010 3:02 pm
I'm having an issue defining a CFF that I don't see addressed in any other threads I've seen. My input file has a header and a trailer, defined by "HDDR" and "TRLR". The data records between the header/trailer do not have a record identifier.
So on the "Records ID" tab, I can define my header with "HDDR" and my trailer with "TRLR", but I don't have any way of defining my data records. The only option I have for an operator ("Op" column) is "=".
Is there a way to set my record type as "all records that do not start with HDDR or TRLR"? I don't really want to split the header/trailer into a separate file, since they contain meta-information I need to validate the rest of the data with. I also cannot use a sequential file because the header and trailer records do not have the same record length as the data records.
Thanks
So on the "Records ID" tab, I can define my header with "HDDR" and my trailer with "TRLR", but I don't have any way of defining my data records. The only option I have for an operator ("Op" column) is "=".
Is there a way to set my record type as "all records that do not start with HDDR or TRLR"? I don't really want to split the header/trailer into a separate file, since they contain meta-information I need to validate the rest of the data with. I also cannot use a sequential file because the header and trailer records do not have the same record length as the data records.
Thanks