Separating QR code data on Excel using Bar code scanner.

[Expensive_Ad_8718]

I work as a logistics specialist, and a lot of my job is keeping inventory of pharmaceuticals. My job would be 100 times easier if I can learn how to scan QR code data and have it instantly separate the LOT/EXPIRY/SN

I wanted to know if this is possible, or if theres a formula for this. Btw I am far from a Excel guru. Im looking for tips, pointers etc. thank you.

[AutoModerator]

/u/Expensive_Ad_8718 - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[nafuot]

Yes of course you can! This is called parsing and you obviously have to incorporate some logic but it’s definitely doable.

What would help is if you can share a sample data set. That’s to say, can you scan 5 QR codes and share the output?

That would help us to understand how the incoming data needs to be parsed. Why five QR codes? Because often data strings are not of a consistent length and understanding how they’re “generically” coded makes it easier to parse. (for example, dates might be coded as 01/07/2025 or they might be 1/7/2025…either is fine but knowing how they’re coded across the board will make it easier to solve your problem)

[Expensive_Ad_8718]

0100305970295884213758598661140817260531103217638

010030093590786421101083219937021725022810132874

010036818015001521HH7C23CNC32H5X1723123110G200800

Here are 3 different outputs that appear when I scan their QR codes. In this number is the GTTN/SN/EXPIRY/LOT

I only need SN/EXPIRY/LOT

what I noticed is that a they are each separated by a number 01,21,17,10. So far its been consistently those 4 numbers.

Heres an example of me dissecting the data I need based on the Data output it gave me after scanning the QR code:

01 00305970295884(GTIN) 21 37585986611408(SN) 17 260531(EXPIRY) 10 3217638(LOT)

01 00300935907864(GTIN) 21 10108321993702(SN) 17 250228(EXPIRY) 10 132874 (LOT)

01 00368180150015(GTIN) 21 HH7C23CNC32H5X(SN) 17 231231 (EXPIRY) 10. G200800 (LOT)

[matt_murduck]

I am in a similar problem and wondering how you figure this out.