Trim Barcode

[SKETCHwade]

Hi Everyone,
I am trying to remove excess information from barcodes. Scanning a couple of items has came back with information like this:

CATAA( – 6I0273
CATAA --3261643
CATAA: – 1R0778
CATAAPH–3375270

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.

Thanks