Notifications
Announcements
No record found.
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.
Hi sir,
For the error message, the first argument to this replace function should be of type string, and you should try adding "" symbol.
learn.microsoft.com/.../er-functions-text-replace
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
MounirDev this formula was supposed to be used in the format mapping, not the mapping!
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.
...
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 584 Most Valuable Professional
André Arnaud de Cal... 499 Super User 2025 Season 2
Sohaib Cheema 254 User Group Leader
