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!
Solved! Go to Solution.
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.
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.
Many thanks, @TeeSee1 !
The function ENCODEURL() did it!
Nice solution @TeeSee1
User | Count |
---|---|
43 | |
28 | |
23 | |
14 | |
14 |