Subject:Add Node and Pattern for Mutlplie Lines(Regions) Author:Praveen Palety Date:03 Mar 2010 09:35 AM
I am trying to create a conversion file to convert a flat file to XML.
Below is the format of the flat file.With in each record it is Fixed Length.I am trying to figure the right approach for this type of file.
Please point me in the right direction. I have attached a sample file.
SCTRL => Start of Control Groups
JDE export data
CTRLH => Control Group Header records
JDE export data
CKHDR => Check Header record
TOF OWAPCHK
JDE Check Header export data line #1
JDE Check Header export data line #2
JDE Check Header export data line #3
JDE Check Header export data line #4
JDE Check Header export data line #5
JDE Check Header export data line #6
JDE Check Header export data line #7
JDE Check Header export data line #8
JDE Check Header export data line #9
JDE Check Header export data line #10
JDE Check Header export data line #11
CKDET => Check detail records
JDE Check Detail export data line #1
JDE Check Detail export data line #2
JDE Check Detail export data line #3
CKDET => Check detail records
JDE Check Detail export data line #1
JDE Check Detail export data line #2
JDE Check Detail export data line #3
CKDET => Check detail records
JDE Check Detail export data line #1
JDE Check Detail export data line #2
JDE Check Detail export data line #3
TOF OWAPOVL (based on N1 setting, N1=3)
CKDET => Check detail records
JDE Check Detail export data line #1
JDE Check Detail export data line #2
JDE Check Detail export data line #3
ECHKS => End of Check records. This also acts as End of Control Group.
ECTRL => End the last Control Group, and it signifies the end of the bridge file.
SCTRL => Start of Control Groups