Bank Statement Loader - Ctl File Issues - SQL Loader Help needed
Hi,
I have to load a bank statement file in the SWIFT940 format. The bank sends some extra info on rec 86 that I need to capture.
Sample Data
:61:1206060606DD1263,35NTRF123//3582158014
/CTC/MSC/FT INTERNAL TRANSFER - DE
:86:/PT/FT/PY/8922615821MAY2012/BI/709991043/BN/
When the standard loader program is ran, the data is stored in the column as follows
/CTC/MSC/FT INTERNAL TRANSFER - DE /PT/FT/PY/8922615821MAY2012/BI/709991043/BN/
I don't want the CTC part to be loaded and I want the record to be loaded from /PT......, because of this i could not read my required value between /PY/ and /BI/ because its adding extra spaces.. and by substr and instr is not working.
I have to load a bank statement file in the SWIFT940 format. The bank sends some extra info on rec 86 that I need to capture.
Sample Data
:61:1206060606DD1263,35NTRF123//3582158014
/CTC/MSC/FT INTERNAL TRANSFER - DE
:86:/PT/FT/PY/8922615821MAY2012/BI/709991043/BN/
When the standard loader program is ran, the data is stored in the column as follows
/CTC/MSC/FT INTERNAL TRANSFER - DE /PT/FT/PY/8922615821MAY2012/BI/709991043/BN/
I don't want the CTC part to be loaded and I want the record to be loaded from /PT......, because of this i could not read my required value between /PY/ and /BI/ because its adding extra spaces.. and by substr and instr is not working.
Tagged:
0