Dear BC Team,
I'm evaluating using BC4 for a project, and am trying to figure out how to ignore only part of a line. The data set is a flat SAP IDoc - all fixed-length fields and no delimeters. When testing IDocs, you will need to ingore the date/time which is generally the last 14 characters or so of the record, but want to compare other data elements and qualifiers.
For example, the first record starts with EDI_DC40 and goes for approx 524 characters. I want to evaluate all records on such a line up to the date/time (here in this example it's "19991001113855" however I'm not sure how to made that happen. You can see that the EDI_DC40 record is padded out to the beginning of the E2EDK01 record.
The example above has actually 3 records (EDI_DC40, E2EDK01 and E2EDK14) -- so being able to ignore part of a file along the lines of
After you find EDI_DC40, compare for 142 characters, then ignore the next 14, then start comparing again. After you find E2EDK01, compare until the next keyword comes.
Doing this with XML IDocs is pretty easy as the DTM fiels are cleanly delimited, but in the flat ones it's a nightmare.
Any suggestions?
I'm evaluating using BC4 for a project, and am trying to figure out how to ignore only part of a line. The data set is a flat SAP IDoc - all fixed-length fields and no delimeters. When testing IDocs, you will need to ingore the date/time which is generally the last 14 characters or so of the record, but want to compare other data elements and qualifiers.
Code:
EDI_DC40 800 40B 3023 ORDERS01 ORDERS ED.96A ORDERSSUBSYSTEM KU 7777 SAPMAT LI 0000001014 19991001113855 E2EDK01003 800 DEM 0.52980 NB 4500016447 E2EDK14 800 0081000
The example above has actually 3 records (EDI_DC40, E2EDK01 and E2EDK14) -- so being able to ignore part of a file along the lines of
After you find EDI_DC40, compare for 142 characters, then ignore the next 14, then start comparing again. After you find E2EDK01, compare until the next keyword comes.
Doing this with XML IDocs is pretty easy as the DTM fiels are cleanly delimited, but in the flat ones it's a nightmare.
Any suggestions?
Comment