I would like to ask for help - I have an issue when I trying to use the “excel formula” in order to separate last 12 digits from the text/number (the number is too long and is not separated correctly)
The case is that when we are trying to scan barcode from FEDEX Shipment - they have the bellow number in the barcode:
1221589622541393824400773629414845
We need to have last 12 digits separated into the separate field as the last 12 digits is the correct shipment number.
Do you have any idea how to do that?
Well since it’s specifically geared towards a FedEx tracking number and a specific format of it, the length is probably going to be consistent, and every position in that barcode is going to serve a specific purpose, so it’s likely to be consistent. Now I guess you could argue that FedEx alone may have different barcode formats, and thus different lengths, but I would hope that there is some logic built into the app to determine the type of barcode data and specifically where the 12 or 14 digit tracking number belongs in the data.
Somewhat unrelated, but we do barcodes on the paperwork we generate where I work. When we print tens of thousands of pages and put the stack of printed paper in our mail processing machine, the barcode tells the machine the start and end of the entire print job, when to break for each customer, whether to fold the paper and shove it in a regular envelope or not fold it and put it in a flat envelope, the page number, the customer id, and I believe if any additional inserts go in the envelope (probably some additional info as well). Every part of that barcode is position specific and contains certain bits of information in each position within that barcode so the mail machinery knows exactly how to process the entire print job with the result being thousands of envelopes machine stuffed and ready to have postage applied and mailed. It also helps the machinery detect any missing pages. I know this because I’m one of the programmers that builds the forms and writes the software to generate and print those forms with customer data along with the appropriate barcode data.
Thank you very much for all the help! It works well!
May I ask you - do you have any idea how to use the App together with the manual PC barcode scanner?
We have staff that are working on the PC but when scanning shipments they are not able to automatically insert the data into the app by the scanner as basic like “Submit by Enter on the keyboard” not working with the text field.
Any idea how to fix that?
