I am trying to remove excess information from barcodes. Scanning a couple of items has came back with information like this:
CATAA( – 6I0273
CATAA: – 1R0778
So “CATAA” is a constant among them, “(” or “PH” is the “origin” of the product.
The numbers on the right are the actual part number that I care about.
I would like to create an expression that fills in [Part Number] based off of [Barcode]
I’ve looked into SPLIT and TRIM, but because the “Origin” is very often different im unsure how to consistently remove everything left of the part number.