Update Field with Exp date and batch after barcode scan

[theinviter]

Dears;
kind support, as i have a form where I want the once scan the QR code on medication to extract the Expiry date and batch.

1- For expiry date to extract and place it in [Expd final] in "yymmdd".
2- For batch number want to see if the code start after "10" more than 2 then take the 2nd 10 and place the number based on number of digits required by user.

I tried but I miss something.

so kind support.

thanks

 

[arnelgp]

when you scan the qrcode, save it to a variable or textfile then examine the content of it and you can
determine which Substring you need to parse/extract.

 

[theinviter]

when you scan the qrcode, save it to a variable or textfile then examine the content of it and you can
determine which Substring you need to parse/extract.

Hi
can you please help me for that and modify my file attached.

thanks

 

[Mark_]

What does your scanner output?

 

[XPS35]

1. It looks like the yymmdd is not always on the same position. This makes it almost impossible to make a procedure that will extract the right value.

2. I do not understand this at all.

 

[arnelgp]

before you Decode your GTIN, review the structure of a GS1 barcode first (you may need to google it).
i think all your barcode is not "well-formed" and does not conform to the standards that is why
you are having a hard time decoding them.