Hi,
I am trying to use the OCRTEXT() function to identify the 36 labels on the trackers in a tray. I have tested photos of 3 trays, below is one example:
To improve the result I provide a sheet named “Code” with a column named “code” that contains the 108 (36x3) possible label codes.
The OCRTEXT() function finds all the labels, and a few false ones, and store them in the “OCR column”. I then use the following code, suggested by @tony1 , to check if the labels found in the OCR Column are present in the Code -column:
SELECT(Code[Code], CONTAINS([_THISROW].[OCR Column], [Code]))
The problem is that this last code always excludes one or two labels found by the OCR that are listed in Code. For this particular picture the OCRTEXT() finds ET01, but the SELECT()-function excludes it.
The other labels, found by OCR, but excluded by the select code are: GT54, AT69 and CT01
What am I doing wrong? How can I exclude the false labels, like “T”, “OMO” etc. without excluding real labels?