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
Is the part you are interested in always delimited by a โ-โ? If yesโฆ you can try a combination of Find() and Right() to leave you with the part you want. See some information here:
Yeah I found something very similar in appsheets examples:
Column AppName with a value of โSales-10305โ
LEFT([AppName], FIND("-", [AppName]))** returns โSalesโ
This works for the most part for me. My current formula is:
IFS(Contains([Barcode],โCATโ),
RIGHT([Barcode], FIND("โ",SUBSTITUTE([Barcode], " ", โโ))),Contains([Barcode],โ742330โ),
โP5โ,AND(Contains([Barcode],โPโ),Contains([Barcode],"-"),LEN([Barcode]) = 15),
LEFT([Barcode], FIND("-", [Barcode]) - 1)
)
With the CAT section I am sometimes left with a space on the left of the part number.
Any Ideas?
Wrap your entire expression in TRIM().
Well I guess itโs just that easy!
Thank you! @Steve
User | Count |
---|---|
40 | |
36 | |
31 | |
23 | |
16 |