Skip to Content
0
Former Member
Sep 08, 2016 at 05:28 PM

Leading Zeros in EFM Add-On for .bfp

108 Views

Hi Everyone,

I'm using the EFM Add-on to format a .bfp file for the MT940 bank statement file format.

I have a problem though with the cheque numbers from the bank statement as it contains leading zeros.

Example: The bank statement file has the cheque number 000000054013 but I want to get only 54013 so that the bank statement processing can recognize them.


This is the regular expression that I have now.

As you can see on the screenshot below the system captures the leading zeroes.

NONREF|(?<=,.{6})\w{1,16}



Attachments

regex.jpg (121.7 kB)
pastedImage_6.png (53.4 kB)