Notifications
Announcements
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…
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 663 Super User 2026 Season 1
Abhilash Warrier 289 Super User 2026 Season 1
Martin Dráb 232 Most Valuable Professional
