Skip to main content
Question

Extracting PO# or Invoice # from a Field into another Field

  • Feb 28, 2018 11:11 PM UTC
  • 0 replies
  • 89 views

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?
This topic has been closed for replies.

  • Qrew Corporal
  • Mar 1, 2018 12:03 AM UTC
Easy - use this native Rich Text formula field:

"<div class='Vibrant Success' onclick=\"var QBU_subject=_fid_6.value;var QBU_matches = QBU_subject.match(/([a-z]?[0-9]{5,})/gi);_fid_7.value=QBU_matches.join('\\n');\">Parse</div>"
Demo below:

Before pressing Parse button:




After pressing Parse button:




Parse With Script
https://haversineconsulting.quickbase.com/db/bnhq45zk4?a=nwr

Pastie Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=642

  • Author
  • Qrew Corporal
  • Mar 2, 2018 12:53 AM UTC
WOW! THANK YOU SO MUCH!!