I want a formula to extract a number out of an email message. Just like you can from a normal text field by using the powerful formula functions.
Use case:
We get the assignment to cost centers of invoices via email and manually write them down. I want the cost center numbers to be extracted from the emails but can’t access the rich text field.
Is there any way to do that with scripting?