HOW TO CONVERT MT940 bank file formate to excel formate

Help Something Else
1

We have tried using python and UiPath. Using UiPath we read the file using read text and tried to extract data using for each loop and regular expressions and wrote data in excel. But partial output obtained. Please help us to extract whole data. Your assistance will be appreciated.

2

Hi @Roshini_Radhakrishnan ,
welcome to forum,
can you share your sample input?
I will test it
read text, read text ocr,… a lot of way to get text
regards,
LNV

4

we can’t upload the data in here so can you try using this

{1:F01BARBINBBXCRA0000000000}{2:I940BARBINBBXXXXN}{4:
:20:059361561230320
:25:04520200000401
:28C:00065/006
:60F:C230302INR2486251,06
:61:230303C10,03NDDT
:86:NDDT/MT940T28/DDISIT/1/
CMS
:61:230303D25,00NTRF
:86:NTRFNEFT BARBD23062397413 BENE6
CMS
:61:230303C12,00NDDT
:86:NDDT/MT940T23/DDISIT/1/
CMS
:61:230303C55,00NMSC
:86:/Communication Failure/BAJAJ FINANCE LTD
CMS
:61:230303D113,28NMSC
:86:Client_code
CMS
:61:230303D55,00NTRF
:86:NTRFIMPS C23062301437 BENE4
CMS
:61:230303C50,00NMSC
:86:/Communication Failure/BAJAJ FINANCE LTD
CMS
:61:230303D50,00NTRF
:86:NTRFNEFT BARBD23062397412 BENE2
CMS
:61:230303D50,00NTRF
:86:NTRFMT940TEST017 BT23030303550199 32990100004074
CMS
:61:230303D25,00NTRF
:86:NTRFMT940TEST011 BT23030303550193 32990100004074
CMS
:61:230303C55,00NMSC
:86:/Communication Failure/BAJAJ FINANCE LTD
CMS
:61:230303D12,03NMSC
:86:059361561 DDISIT
CMS
:61:230303C12,03NDDT
:86:NDDT/MT940T29/DDISIT/1/
CMS
:61:230303D200000,00NTRF
:86:NTRFRTGS BARBR22023030320200845 BENE5
CMS
:61:230303D55,00NTRF
:86:NTRFIMPS C23062301436 BENE8
CMS
:61:230303D55,00NTRF
:86:NTRFMT940TEST013 BT23030303550195 32990100004074
CMS
:61:230303C12,01NDDT
:86:NDDT/MT940T25/DDISIT/1/
CMS
:61:230303C12,02NDDT
:86:NDDT/MT940T27/DDISIT/1/
CMS
:61:230303C10,01NDDT
:86:NDDT/MT940T24/DDISIT/1/
CMS
:61:230303D50,00NTRF
:86:NTRFIMPS C23062301438 BENE10
CMS
:61:230303C1000,00NCOL
:86:NCOL/
CMS
:61:230303C10,02NDDT
:86:NDDT/MT940T26/DDISIT/1/
CMS
:61:230303C10,00NDDT
:86:NDDT/MT940T22/DDISIT/1/
CMS
:62F:C230303INR2287008,87
-}

5

Can you tell how you do the same in python. It will help??