Hi,
I have a very complex flat file which looks like this.
FFM/8
1/AI0123/12JAN1212/BOM/reg12/GB/12JAN1212LHR
DXB/Nil/12JAN1212/12JAN1212
098-12345678BOMLHR/S5000W12KG12DI49S5000/Goods
/SHA/SHA
DIM/W12/CM12345-234-567/5555
/BOMAI0123/12FEB
/M
Lin/OSIBULK1
/OSIBULK2
COR/C
OCI/GB/Inf/C/Supplementary_Cust
LAST
From Third line to second last line is a repeating group like-
DXB/Nil/12JAN1212/12JAN1212098-12345678BOMLHR/S5000W12KG12DI49S5000/Goods
/SHA/SHA
DIM/W12/CM12345-234-567/5555
/BOMAI0123/12FEB
/M
Lin/OSIBULK1
/OSIBULK2
COR/C
OCI/GB/Inf/C/Supplementary_Cust
In this group all the lines are optional except first line. And only last line has a tag identifier "OCI". further in first line i.e. "DXB/Nil/12JAN1212/12JAN1212" contains "/" delimiter. and in this record only first element is mandatory rest are conditional or optional. this continues with every other line.
I dont know how to proceed with such file. Any help would be appreciated.
Regards,
Alok Tripathi
- Edited by aloktripathi Monday, June 04, 2012 12:46 PM wrong description
- Changed type aloktripathi Monday, June 04, 2012 1:56 PM