Hello everyone, i'm trying to import a bank statement that has a bank account id that starts with :25: ,(Swift file) but i cannot import without adding a '/' manually, so i will become like that :25:/, im trying to create a formula in the formula designer that automatically adds the '/'. but im facing some issues. Note that Im using the latest format version.
i already tried to use this formula in the format mapping too, but its giving same error message. i dont know what is the problem if the formula is incorrect.
i also tried this formula: SPLIT( REPLACE( REPLACE(format.StatementFile.FileContent,"(\r\n|\r|\n):25:","(\r\n|\r|\n):25:/",true) , "(\r\n|\r|\n):20:", "?:20:", true) , "?:20:")
but its wrong too.
...
MounirDev this formula was supposed to be used in the format mapping, not the mapping!
hi sir,
please can you provide me with the formula that i can add in order to have the '/' automatically replaced, because i need to import ABR MT940 format, the swift format have a bank account that starts with :25: , i need it to be :25:/
thanks alot
Hi sir,
For the error message, the first argument to this replace function should be of type string, and you should try adding "" symbol.
André Arnaud de Cal...
292,031
Super User 2025 Season 1
Martin Dráb
230,868
Most Valuable Professional
nmaenpaa
101,156