Hi,
I have a strange flat file that has a non-repeatable structure,such as sometimes I have a missing lines.
I was wondering if it is possible to mark such lines as optional... here is an example:
UNA:+.? '
UNB+UNOB:1+PINID00:AA+0016520:AA+060928:1930+00000109281935'
UNH+1+DELINS:3:0:OD:INTESA'
MID+55676+060928'
SDT+::::::016520'
BDT+094000489110015:PININFARINA S.P.A.++++IT'
ARI+2+061003:061003+3'
CSG+094000489110015:PININFARINA S.P.A.:::::MG3+:PININFARINA S.P.A'
ARD+946156063421+:PCE+02350:050419+++:00390124494335'
PDI+308978+060927'
SAD+2++++2'
DST+061001+8:9:-1'
PDN+211287:060623'
DEL+061003+0::0:1:0:0'
ARD+946156063423+:PCE+02350:050419+++:00390124494335'
PDI+308979+060927'
SAD+2++++2'
DST+061001+7:7:0'
8 lines wich is the header i'm not really interested on.
The structure I'm intereset on begin with ARD and ends with DEL. But as you can see sometimes the PDN line is missing....
I created a fixed value mapping where each lines has the 1st chars as ID and each new line is child of the previous
Is there a way of solving such a problem?
Thankx in advance,
Ale
I have a strange flat file that has a non-repeatable structure,such as sometimes I have a missing lines.
I was wondering if it is possible to mark such lines as optional... here is an example:
UNA:+.? '
UNB+UNOB:1+PINID00:AA+0016520:AA+060928:1930+00000109281935'
UNH+1+DELINS:3:0:OD:INTESA'
MID+55676+060928'
SDT+::::::016520'
BDT+094000489110015:PININFARINA S.P.A.++++IT'
ARI+2+061003:061003+3'
CSG+094000489110015:PININFARINA S.P.A.:::::MG3+:PININFARINA S.P.A'
ARD+946156063421+:PCE+02350:050419+++:00390124494335'
PDI+308978+060927'
SAD+2++++2'
DST+061001+8:9:-1'
PDN+211287:060623'
DEL+061003+0::0:1:0:0'
ARD+946156063423+:PCE+02350:050419+++:00390124494335'
PDI+308979+060927'
SAD+2++++2'
DST+061001+7:7:0'
8 lines wich is the header i'm not really interested on.
The structure I'm intereset on begin with ARD and ends with DEL. But as you can see sometimes the PDN line is missing....
I created a fixed value mapping where each lines has the 1st chars as ID and each new line is child of the previous
Is there a way of solving such a problem?
Thankx in advance,
Ale
