have a requirement here, where i have to debatch a FF file and feed it to
Orchestration Engine for processing.
The FF looks like:
CU20100210221BSINET STREAMING TEST TCS STREAMING TEST FOR COMM
065148145703660 VICTORIA STREET NORTH SHOREVIEW MN551263503Y
OR20100210221790128319230920102121201091000010000210540000030000001050000001400AL000100002105400000000000000000000128
PD20100210221010008016400123091000010124567890
000100003040000724080001230000150000000030000001050000001000
OR20100210221790128319230920102121201091000010000210540000030000001050000001400AL000100002105400000000000000000000128
PD20100210221010008016400123091000010124567890
000100003040000724080001230000150000000030000001050000001000
?
Each Record : CU, OR, PD is of 210 length. But if the optional fields are
not present they would be padded by whitespaces. The FF should be split
into
individual XML's with CU-OR-PD records or OR-PD records i.e. CU or OR
marks
the beginning of the Order,and PD marks the end of a file. It is worth
mentioning that only PD record is unbounded.
Could someone suggest a way to do this? Is this splitting a FF
disassembler
- pipeline thing or Orchestration - xpath thing?
Note: Application could send Header/Trailer info if required. Any other
changes to the FF could still be suggested for easier processing by
BizTalk.