Solved: Re: FNC1 in scanned string

MyPill · 10-30-2023 05:35 AM

Hi,

I try to scan 2D matrix code that includes four information, all of them start with nonvisible character FNC1. I need to split scanned string according to this nonvisible character. When I scan the code I can see the nonvisible characters in the string as a crossed rectangle, but this character cannot be copied nor it is included in the saved string in the table.

For example: this is the saved string - 0103830044943141210003F10RH3D417250228102302029A. But the original code with nonvisible characters (I use ¤ for illustration) is ¤0103830044943141¤210003F10RH3D4¤17250228¤102302029A.

The problem is that none of the information has set number or characters so I cannot split the string according to the length of each element. So I need to identify the delimiter.

Thanks!

TeeSee1

Not sure if this would help but..

Reading this code

results in

"%1D20011111122821000001%1D%1D240ActiveBarcode"

if you create another column with the following AppFormula in addition to the Scanner column (call it [QR]).

IF(ISBLANK([_THIS]),
 ENCODEURL([QR]),
 [_THIS]
)

[QR] loses all the FNC1 after data save but this Encoded field retains it as "%1D"

It seems that my scanner misses some FNC1 characters and probably would cause issues. But if your scanner recognizes all the FNC1 characters at the initial scan, then you might have a chance to encode them and save them for later processing.

View solution in original post

TeeSee1