New User? Sign Up  |  Sign In  |  Help
Barcode support and
tutorials from IDAutomation
and the community.
Click for the BBB Business Review of this Computers Hardware, Software & Services in Tampa FL
Resolved Questions

How to format IMpb or GS1 Human Readable in Excel to Mail Merge using Barcode Fonts?

I need to encode data for IMpb in Excel and then merge the encoded data into another application. I can do this but I cannot create the correct human readable. This is what I need:
image

This is what I receive when I use the Code 128 Font Package with the IDAutomationVBA font encoder.
image

I need to remove the highlighted part of the human-readable and also need the human-readable separated. How can I do this? By the way, the barcode scans fine.

Operating System: Windows

Application: Excel 2013
Attachments:

08-12-14     9.5 year(s) ago    

  Report Abuse

 

Ben

Best Answer

NOTE: When generating GS1 symbols, IDAutomation recommends testing the result with the Barcode Decoder App which parses out GS1 data to verify proper encoding.

It is possible to create separate fields to store the barcode and the human-readable. In this example, I will explain how to create a barcode field and a human-readable field that removes unwanted human-readable values while appropriately splicing the text so that it is in the correct format. My example will use the data:

(420)010021860(92)47290762700100015402


The data in parentheses, 420 and 92, are Application Identifiers that require an FNC1. The data also requires a MOD10 check digit.

1. View the IDAutomationVBA installation post until Step 8 is completed.


2. In Column A2, enter the data: (420)010021860(92)47290762700100015402~m21
(The ~m21 will calculate a check digit using the 21 digits from right to left)
image


3. In Column B2, enter the formula for Code 128 that will encode the data: =Code128(A2,0,True)
image


4. In Column C2, enter the formula to display the human-readable for Code 128. The RIGHT function will remove the desired amount of characters. The SpliceText function (from the IDAutomationVBA), will split the text into the appropriate format:
=SpliceText(RIGHT(Code128(A2,1,TRUE),LEN(Code128(A2,1,TRUE))-23),4)
image

Adjust the number of characters to remove to account for spaces.


5. Merge into the desired application and apply the IDAutomationC128M (IDAutomationSC128M - demo font) to the Encoded Data field. Place the Human Readable field either above or below the barcode.
image

Barcode Font Applied:
image

IMpb:
image

Posted 9.5 year(s) ago

(0)
(0)
  Report Abuse
 
Find Interesting
 
Email to Others
 
Bookmark
 
Subscribe to Answer Alert
No comments yet.     Be the first to comment.

Email this question link to friends
You must enter an email address, if name is entered or vice-versa for each friend.
Friend #1 -
Friend #2 -
Friend #3 -
Friend #4 -
Friend #5 -
  Your comment on this question
  |         |  
bold  italic  underline  strike       big  small       superscript  subscript 
  Allows to add a link. Added links would only be converted to actual clickable link, when the domain of the link is white-listed by administrator.
Caption :
Link URL :
(Must starts with "http://")
Add  |   Cancel
  Allow to insert an image. Must be among the following file types - *.jpg, *.gif, *.png & *.bmp.
Image Url :   Upload New
(Image url must always starts with " http:// ")
Width : pixels
(Must not be greater than 450px. Enter 0px for no resize)
Add  |   Cancel
  Allow to insert YouTube video. Insert the video embed code.
Embed Code :
Add  |   Cancel
Up to 5000 Characters are allowed. Current Count: 0
  Your comment on this answer
  |         |  
bold  italic  underline  strike       big  small       superscript  subscript 
  Allow you to add a link. Added links would only be converted to actual clickable link, when the domain of the link is white-listed by administrator.
Caption :
Link URL :
(Must start with "http://" or "https://")
Add  |   Cancel
  Allow to insert an image. Must be among the following file types - *.jpg, *.gif, *.png & *.bmp.
Image Url :   Upload New
(Image url must always start with "http://" or "https://")
Width : pixels
(Must not be greater than 450px. Enter 0px for no resize)
Add  |   Cancel
  Allow to insert YouTube video. Insert the video embed code.
Embed Code :
Add  |   Cancel
Up to 5000 characters are allowed. Current Count: 0

You may answer and comment on any thread according to the Terms and Conditions.

 © Copyright 2021 IDAutomation.com, Inc., All Rights Reserved. Legal Notices.

 Barcode Fonts | Components | Scanners | Support | Contact Us
Training Videos on YouTube Join us on Google Plus Join us on LinkedIn Follow us on Twitter Like us on Facebook