pharmavenger
New Member
- Joined
- Jul 19, 2019
- Messages
- 7
Hello everyone!
I'm a pharmacy student working on how to extract numbers from medication QR codes into individualized columns in Excel.
For example, this code[TABLE="width: 370"]
<tbody>[TR]
[TD="class: xl63, width: 370"]010030093552606517201130101040951182110091947809740 needs to put into 3 columns: GTIN, Lot, and Expiry date. GTIN is donated by 01 in front and has a 14 fixed digit. Lot number is denoted by 10 and the digits may vary (its not fixed so that is why we were having trouble). Expiry date is denoted by 17 and its fixed at 6 digits.
I have tried the following code: =LEFT(MID(A1,SEARCH("17",A1)+2,LEN(A1)),FIND("21"-1,MID(A1,SEARCH("17",A1)+2,LEN(A1)))-1)[/TD]
[/TR]
</tbody>[/TABLE]
This is an screenshot of what I'm working towards: https://paste.pics/0d7ee6a250f7a17721281285a2985621
This is more information on the code: https://paste.pics/7622d1f5f0708387defb889dab03198b
Any advice is helpful. Thank you!!!
I'm a pharmacy student working on how to extract numbers from medication QR codes into individualized columns in Excel.
For example, this code[TABLE="width: 370"]
<tbody>[TR]
[TD="class: xl63, width: 370"]010030093552606517201130101040951182110091947809740 needs to put into 3 columns: GTIN, Lot, and Expiry date. GTIN is donated by 01 in front and has a 14 fixed digit. Lot number is denoted by 10 and the digits may vary (its not fixed so that is why we were having trouble). Expiry date is denoted by 17 and its fixed at 6 digits.
I have tried the following code: =LEFT(MID(A1,SEARCH("17",A1)+2,LEN(A1)),FIND("21"-1,MID(A1,SEARCH("17",A1)+2,LEN(A1)))-1)[/TD]
[/TR]
</tbody>[/TABLE]
This is an screenshot of what I'm working towards: https://paste.pics/0d7ee6a250f7a17721281285a2985621
This is more information on the code: https://paste.pics/7622d1f5f0708387defb889dab03198b
Any advice is helpful. Thank you!!!
