
Announcements
Hello,
I am looking to remove a reference number that can appear anytime in the body of email as there is no template used by the sender.
For example:
Hello - Please find the reference number CF(9 digit number) if you need anything please let me know.
So essentially I need a way to extract that reference number and the CF never changes as well
Hi @amenegatti ,
One way to achieve this is by using the substring function as shown below: