FNC1 in scanned string

AppSheet AppSheet Q&A
,
1

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!

2

Not sure if this would help but..

Reading this code

TeeSee1_0-1698729302593.png
TeeSee1_0-1698729302593.png607Ă—200 27.6 KB

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”

TeeSee1_1-1698729542478.png
TeeSee1_1-1698729542478.png642Ă—165 11.8 KB

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.

1 Like
3

Many thanks, @TeeSee1 !

The function ENCODEURL() did it!

1 Like
4

Nice solution @TeeSee1