I would like to user Regex to to parse out additional digits in a scanned barcode and compare the result to the data in a column of a separate table.
Example
Scanned barcode: 030076126007348
Table contains: 761260073
I was able to find how to for the regex evaluation but not how to take the result and use it in a dlookup.
Thanks to anyone who can help,
_D
Example
Scanned barcode: 030076126007348
Table contains: 761260073
I was able to find how to for the regex evaluation but not how to take the result and use it in a dlookup.
Thanks to anyone who can help,
_D