GS! Barcodes

deanl33069

Board Regular
Joined
May 2, 2019
Messages
120
Has any one done any work with GS!-128 bar-codes, as far as scanning into spreadsheet by AI numbers?
 

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.
That's GS1-128 barcodes?

They have a structure: to build the barcode
Start Code
Function Codes
etc etc

These are product barcode I think, and can be quote long in length

The code broken down into subsets, and follow a criteria

If you can a code via a barcode reader you should be able to get the numeric into a cell of Excel and reference that the a look up table

I did this of std 128 codes years ago

Not sure if that helps, all codes should read into Excel ok, them you need to sort out the returned data for whatever you require

Regards
juil
 
Upvote 0
ty I am trying to be able to break them down to the AI feilds by weight , pack date serial number,,,,ect
(01)90027182300349(3201)000239(11)190422(21)0058800311

this is a sample the (01) is the GTIN # (3202) is weight with 2 decimal place& 6 numbers (11) is pack date with 6 numbers and (21) is the serial number
sometimes the AI are in different places....
and not always inside ().
 
Upvote 0

Forum statistics

Threads
1,224,823
Messages
6,181,181
Members
453,022
Latest member
Mohamed Magdi Tawfiq Emam

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top