I’m playing around with building an inventory app, the barcode scanning is throwing me for a loop.
The “tag” we use is a datamatrix which contains 3 sets of data separated with a “/” the actual number we are trying to match on is the 2nd set of data. When you scan it is trying to match on the entire string. How can I make it match just on the 2nd set of data?
Please explore if following helps.
You may create another column , called say [ExtractedScan] with an expression something like
INDEX(SPLIT([Scan Column], " /") , 2 )
Then you may match with this extracted scanned barcode data column.
I could not test it though.
Yeah the problem is we don’t already know the last bit of data that is in the barcode… not something that was ever tracked so when we scan it that is the first time we know about it.
Thank you for the update. You may wish to further elaborate your recent update.
May we know if you mean the data is not consistently in the format something like
1234 /1234567890123 / 54321
If it is feasible for you to share a consistent scanned data pattern and the desired extract you wish out of it, community may be able to suggest a solution.
Edit : A similar post , just in case it helps.
[Split Tab-Delimited Text From Scanned QR code](https://community.appsheet.com/t/split-tab-delimited-text-from-scanned-qr-code/22950) Questions
I have QR codes on shop floor documents that contains entries for Item Code, Julian Code, Best Before Date and Production Date. Each of these entries is delimited by a tab (Ascii code 9), for example CODE010 0109 18/04/2021 18/04/2020. My question is - how do I split out each entry, so that I can put them into their own fields? I’ve tried playing with the SPLIT function but cannot seem to find out how to identify the tab (for example, in Excel, if the above was in cell A2, I’d use =MID(A2,1,F…