Does anyone know how to parse a flat file that has multiple record types and some of the records types have field delimiters and some are fixed length.
For example: A Purchase Order (PO)
Header id = 001 and holds Purchase number & date and each field is fixed length
Shipper id = 002 and holds address information, each address field is delimited by a | character.
002S852|John Brown Shipping|123 West Drive
My thought is to parse the flat file twice, once with a fixed length schema just pulling out the Headers and then again with a character delimited schema. The only issue I have is matching the data together afterwards.