Resolved Questions

FulanoNadie

Alternate UID DataMatrix Implementation in a Merge

Tagged With:-

We were following the MIL-STD-130 UID Marking Label Generation tutorial to form UID DataMatrix barcodes.

We need a way to join the various bits of the final string in Excel before merging with another program (be it the Barcode Label Software, InDesign, Word, etc):

[)>~d03005~d029800406141419999960MH80312~d02921MH80312
~d029950614141~d02924099999~d030~d004

What is your suggestion?

11-23-16 7.9 year(s) ago

Report Abuse


James	Best Answer The tutorial guide you mentioned serves as a general guide (see the documentation specific to your needs to adjust the various bits of the final data in Column 19). General Notes: • For this work, you must enable ApplyTilde (or ProcessTilde) in the Barcode Label Software or the IDAutomation encoding function – see the respective documentation for more details. • The green and yellow columns in the below picture are to show an example of the Serial Number section being split to allow Excel to auto-number down (press Ctrl and drag down the numbers in yellow to auto-increment). • The data in columns 1-18 are all formatted as Text and Column 19 is formatted as General (so the CONCATENATE function will work correctly). • The example below may not be perfectly accurate from a UID DataMatrix perspective, but it is provided as a very general guide. • The user may do this in any way they wish, using 18 columns of data just allows each section to easily be edited for future use. • Refer to Microsoft’s Excel guides for Excel-specific questions. Example Image (cell S2 chosen to show the formula and result – click to open image): Posted 7.9 year(s) ago (0) (0) Report Abuse

Find Interesting

Email to Others

Bookmark

Subscribe to Answer Alert

Add Comment

No comments yet. Be the first to comment.

Categories

» Barcode Applications » Barcode Components ● Barcode FAQ » Barcode Fonts » Barcode Hardware ● Barcode Learning » Font Encoders ● General License Questions ● General Sales Questions » MICR & OCR Fonts » Other ● Product Updates » Saas Hosted Products

Email this question link to friends

Your comment on this question

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

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

My Profile

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