topic Re: Processing MT 940 files in Talend Studio

Processing MT 940 files

gtaware — Fri, 18 Oct 2019 09:45:57 GMT

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 .

Re: Processing MT 940 files

Anonymous — Wed, 06 Nov 2019 08:03:22 GMT

Hello,

Here is a related topic about splitting one row into header, detail and trailer records in Talend

https://community.talend.com/t5/Design-and-Development/Splitting-one-row-into-header-detail-and-trailer-records-in/m-p/198995

Let us know if it could help.

Best regards

Sabrina

Re: Processing MT 940 files

gtaware — Thu, 14 Nov 2019 18:04:02 GMT

Hi All Experts ,

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

:61:1812281228D2500,00NTRFRCMS
FPX One-off Impl'tion Fee-Nov18

:61:1812281228D355,12NTRFCITI1819387740638659
CITI514486527783

Out of which immediate next line is Transaction Description

:61:1812281228D2500,00NTRFRCMS
FPX One-off Impl'tion Fee-Nov18

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 .

Requirement.docx