Extracting PO# or Invoice # from a Field into another Field
From a subject field, I would like to extract any number that may be a PO# or Invoice #. For example, the subject field may say, "Strong-Tie Invoices W987567 and W23234324 on your PO# 27987324 due 3/25/2018."
The invoice or po #'s will always contain a number and sometimes contain a letter. What is the best way to isolate and list these numbers in another field?
The invoice or po #'s will always contain a number and sometimes contain a letter. What is the best way to isolate and list these numbers in another field?
