|
next
|
Subject: Varying Length Multiple Record Fixed Width Flat File to XML Author: Derrick Exum Date: 12 Sep 2008 02:55 PM
|
How do I go about creating a Conversion for a Fixed-Width Multiple Record fixed file when there are no separators between the fields?
Each record type has different fields of varying lengths. The fields are layed out by their position. The first 2 columns denotes the RecordType. After that the records vary depending on record type.
Example
RecordType 01
01001Albany 2006CVS090077
RecordType 02
02Alexander,Jane,Smith
RecordType 03
03097012TExpired Inspection
The layout for Record type 1 is First2 colums = RecordType, Colums 3-5 = CountyCode, 6-17 = CountyName, 18-21 = Year, 22-24 = DataRecordType etc.
The layout for RecordType 2 is First 2 columns = RecordType, Columns 3-30 = PersonsName(comma delimited)
The layout for RecordType 3 is First 2 columns = RecordType Columns 3-4 = SequenceNo, Columns 5-8 = ChargeCode, Columns 9 = ChargeType, Columns10-54 = Charged description etc.
Does anyone have any ideas?
|
|
|