QR code vs Barcode and keyboard input

Hello,

I am struggling with a textbox input. I am using a scanner to input a value into a textbox. When the scanner sees a barcode the input is correct and to size such as. xxxxxx-xxxx, this is also correct with a keyboard entry. However, when the qrcode is scanned I receive an extra long code that has the above mentioned barcode scan sequence in it, minus the hyphen, with numbers and/or letters before and after it. How do I remove both the letters/numbers before and after the needed text string and add the hyphen. The location of the hyphen will always be before the last four digits and the code I need will be this standard length. The reason I ask is some of our products only have the QR code and the scan is somewhat quicker than the keyboard. Thanks.

You'd need to give sample of few QR code as it's appearing now and how it should appear after manipulation.

Code will largely depend on what variations will be there before and after the needed string.

QR Code is as follows: R4100102930$1$200vdl$$h235$-----
Bar code: 410010-2930
The excel sheet I am using for inventory check, pick and add is setup with the bar code layout so I need the QR code to match the bar code.
Thanks

Something like below. So assign QR Code string to a variable then use split function to extract string before "$". Then use Replace to remove "R". And then use Format to insert "-" at specific position.

Please Login or Register  to view this content.

If you want, you can combine it into single line.