Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Answered

MT940 statement format setup line 61 formula for pulling bank document number

(0) ShareShare
ReportReport
Posted on by 40

Hi everyone,

Good day to all, i am trying to update existing ER design formula to get document number after "//" as my MT940 file line 61 contains document number but some lines will contain characters. Example 
:61:2304201111CD11,80NTRFTest company//01359
Result:01359
:61:2304201111CD11,80NTRFTest company//DOC1234
Result: 1234
:61:2304201111CD11,-//MMB11289578698201?12345678
Result: 11289578698
:61:2304030678OC14,40NTRFTesting Company//T67584965789201?123456
Result:67584965789

My current formula:

IF(CONTAINS(@.Line61, "//"), RIGHT(FIRST(SPLIT(INDEX(SPLIT(@.Line61, "//"), 2).VALUE, "201?")).VALUE, Len(FIRST(SPLIT(INDEX(SPLIT(@.Line61, "//"), 2).VALUE, "201?")).VALUE) - 3), "")

 

  • Benjamin long Profile Picture
    Benjamin long 40 on at
    RE: MT940 statement format setup line 61 formula for pulling bank document number

    Hi Judy,

    Thank you so much for your response, I manage to get the formula to work.

    IF(CONTAINS(@.Line61, "//"), REPLACE(FIRST(SPLIT(INDEX(SPLIT(@.Line61, "//"), 2).VALUE, "??")).VALUE, "[^0-9]", "", true), "")

  • Verified answer
    huijij Profile Picture
    huijij 19,811 on at
    RE: MT940 statement format setup line 61 formula for pulling bank document number

    Hi sir,

    You can start with a small part of the function and test it, then see what the real problems are.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,162 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,962 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans