Hi,
I am trying to create a public function that extract an eight digit number after a variation of the string, invoice number, in a row.
For example, if a row has "invoice rejection, po 90449033, invoice number 12345678", I want the function to extract only the invoice number.
The closest I was able to find is a function that counts the nearest 8 digit number in a row of text but not sure how to expand it to only extract the number after a certain phrase.
By variation of invoice number, I mean to extract the number after determining if it meets multiple options (inv or invoice number or invoice)
I am trying to create a public function that extract an eight digit number after a variation of the string, invoice number, in a row.
For example, if a row has "invoice rejection, po 90449033, invoice number 12345678", I want the function to extract only the invoice number.
The closest I was able to find is a function that counts the nearest 8 digit number in a row of text but not sure how to expand it to only extract the number after a certain phrase.
By variation of invoice number, I mean to extract the number after determining if it meets multiple options (inv or invoice number or invoice)