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: