We are in a requirement to use enterprise technologies like REST/SOAP/JSON/XML/JDBC/SFTP/XSD (Oracle). Our use cases are like, Exposing services (REST/SOAP), Reading from file like MT940, CSV, flat files and storing in oracle database, Using SFTP, File Movements frequently.
Mt940 file details are provided on Google and Sample files are attached . Kindly guide for the same
Basically this file contains Header , Transaction and Footer Information . I want to split it out and then put into separate files .
I have below file format . This is one of standared format of MT940 file
{1:F01XXXXXXXXXXXX0000000000}{2:I940XXXXXXXXXXXXN}{4: :20:3067310 :25:514486527783 :28C:1/1 :60F:C181128MYR12658,54 :61:1812281228C125,12NCOL851711644078226 851711644078226 NG KIM LAI :61:1812281228D25,12NCOL851711644078226 851711644078228 NG KIM LAI :61:1812281228D2500,00NTRFRCMS FPX One-off Impl'tion Fee-Nov18 :61:1812281228D355,12NTRFCITI1819387740638659 CITI514486527783 :62F:C181128MYR17271,48 :64:C181128MYR17271,48 -}
From This file I have below requirement
1. First and Last Line to be removed
2. Read only Line with TAG = :61:
Now here is a challange , When I say read only with TAG -61 means we have to read next line of 61 also . In above example , I have to read below lines
:61:1812281228C125,12NCOL851711644078226 851711644078226 NG KIM LAI
:61:1812281228D25,12NCOL851711644078226 851711644078228 NG KIM LAI
In final output file I am expecting below Information to be populated
181228|D|2500,00|FPX One-off Impl'tion Fee-Nov18
181228|C|125,12|851711644078226
181228|D|25,12|851711644078228
Now here lets consider one of example of 61 TAG :
:61:1812281228C125,12NCOL851711644078226 851711644078226 NG KIM LAI
Here '1812281228C125,12NCOL851711644078226' from this string :
First 6 character are DATE ( YYMMDD) --->181228
Next 2 character are FundDATE (MMDD) -->1228
Next 1 character is indicator ( credit /debit ) --C
Next 5 chracter is Ammount --125,12
Rest information is not required
and from string '851711644078226 NG KIM LAI'
if First 15 character are Numeric and does not contain valus as ' CITI' then read only 15 character
else
if First 15 character are Non Numeric and does not contain valus as ' CITI' then read all the character
else First 15 character are Non Numeric and does contain valus as ' CITI' then then ignore that TAG
Hence I am expecting final output as :
Date | Indicator | Ammount | Reference
181228|D|2500,00|FPX One-off Impl'tion Fee-Nov18
181228|C|125,12|851711644078226
181228|D|25,12|851711644078228
I really need to develope a generic approach to read such type of data . Because In future I may have another TAG with same kind of details so that I can utilize the same .
Also withing that I need to add looging details such as - How many records read , How many as C and D like that . But it is a secondary requirement .
