Barcode app for rewriting parts of a code.

[jindrich]

Hello.

I have a question: I'm creating an app for a waste barcode. And I have to rewrite the barcode with the button. This means that you need to scan the barcode because it is bad in the database and you need to change several pieces of code.

Example: I have a code (000067049A 240) and need to overwrite the code by selecting 80 (80 liter bin) from the options list and the code will be changed to (00006709A 80) and then saved to excel.

Thank you in advance for your reply Jindra.

[v-yutliu-msft · Accepted solution]

Hi @jindrich ,

Do you want to change the barcode scanner scanned value from "000067049A 240" to "00006709A 80"?

If so, I use "BarcodeScanner1.Value" to represent  the barcode scanner scanned value "000067049A 240".

Then try this formula to modify scanned value:

Concatenate(
            Left(First(Split(BarcodeScanner1.Value," ")).Result,7),
            Right(First(Split(BarcodeScanner1.Value," ")).Result,2),
            " 80"
            )

 I see "00006709A 80" as three parts: "0000670","9A" and " 80".

Best regards,