Okay so you are saying that I can't use $K? Many web sites seem to indicate you can create the tab in the code three of nine? It might be that there is some other way? I have seen ~ mentioned for example?
Main Topics
Browse All Topics
Loading Advertisement...
Question
Embedding a "tab" in a three of nine extended barcode
How can I embbed a "tab" character in a three of nine extended barcode in Excel? I an using a three of nine extended true type barcode to generate the barcodes which are working okay but I really need to get a tab command in the middle of the barcode e.g.
USERNAME<TAB>PASSWORD
Currently I am using the following in Excel with the three of nine barcode selected.
="*USERNAME*"
="*PASSWORD*"
This produces two barcodes, one for username and one for the password. I have tried the following but without success.
="*USERNAME%KPASSWORD*".
Do you know how I can produce the <tab> in the middle?
I have attached the barcode file. You need to rename to .TTF and install in windows fonts
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Subscribe now for full access to Experts Exchange and get
Instant Access to this Solution
- Plus...
- 30 Day FREE access, no risk, no obligation
- Collaborate with the world's top tech experts
- Unlimited access to our exclusive solution database
- Never be left without tech help again
Trusted by hundreds of thousands everyday for fast, accurate and reliable tech support.
- "The time we save is the biggest benefit of Experts Exchange to Warner Bros. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange." Mike Kapnisakis, Warner Bros.
- "Our team likes having a resource that is more secure than just using Google and most experts using this service really know their stuff. It's nice to look here first versus using Google." Dayna Sellner, Lockheed Martin
- "Anytime that I've been stumped with a problem, 9 out of 10 times Experts Exchange has either the accepted solution or an open discussion of the potential solution to the problem." Kenny Red, eBay Inc.
See what Experts Exchange can do for you.
Got a question?
We've got the answer.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
Need individual assistance?
Our experts are ready to help.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Want to learn from the best?
Read articles from industry experts.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Working on a long term project?
Store your work and research.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
What Makes Experts Exchange Unique?
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Trusted by the world's most respected brands.
Faithfully serving IT professionals since 1996.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Free Tech Articles
-
WARNING: 5 Reasons why you should NEVER fix a computer for free.
It is in our nature to love the puzzle. We are obsessed. The lot of us. We love puzzles. We love the challenge. We thrive on finding the answer. We hate disarray. It bothers us deep in our soul. W...
-
SCCM OSD Basic troubleshooting
SCCM 2007 OSD is a fantastic way to deploy operating systems, however, like most things SCCM issues can sometimes be difficult to resolve due to the sheer volume of logs to sift through and the dispe...
-
Migrate Small Business Server 2003 to Exchange 2010 and Windows 2008 R2
This guide is intended to provide step by step instructions on how to migrate from Small Business Server 2003 to Windows 2008 R2 with Exchange 2010. For this migration to work you will need the fo...
-
Create a Win7 Gadget
This article shows you how to create a simple "Gadget" -- a sort of mini-application supported by Windows 7 and Vista. Gadgets can be dropped anywhere on the desktop to provide instant information, ...
-
Outlook continually prompting for username and password
There have been a lot of questions recently regarding Outlook prompting for a username and password whilst using Exchange 2007. There are a few reasons why this would happen and I will try to cover t...
-
Backup Exchange 2010 Information Store using Windows Backup
There seems to be quite a lot of confusion around the ability to backup Exchange 2010 using the built in Windows Backup feature. This stems from the omission of this feature prior to Exchange 2007 s...
Cloud Class Webinars
- Avoiding Bugs in Microsoft Access
Alison Balter takes and in-depth look at avoiding bugs in Access. In this webinar you will learn about using the immediate window to debug your applications, invoking the debugger, using breakpoints to troubleshoot, stepping through code, setting the next statement to execute, ...
- Top 10 Best New Features in Visio 2010
Scott Helmers gives live demonstrations of the top 10 new features in Visio 2010. This webinar will teach you how to create compelling diagrams by adding shapes to the page with a single click, linking the shapes in a diagram to data in Excel (or SQL Server, or SharePoint), ...
- IT Consultant Business Secrets Revealed
Michael Munger, Experts Exchange tech pro and IT consultant, pulls back the curtain on his very successful businesses and answers question on every IT consultant and business owner should know about. He shares secrets on what he did to solve the 5 most common problems in IT, ...
- Disaster Recovery and Business Continuity
Quest CTO, Mike Billon, gives an overview of the steps involved in building a dunamic disaster recovery plan. Through case studies and an examination of software/hardware tooles for monitoring and testing, you'll gain a better understandin of where you are, where you want ...
- Organize Your Visio Diagrams with Containers and Lists
Scott Helmers uses cross functional flowcharts, wireframe diagrams, data graphic legends and seating charts to teach you: how to ustilize all three new structured diagram components in Visio 2010, the best practices for organizeing shapes in previous version of Visio, how to organize ...
- How to Us Objects, Properties, Events and Methods in Microsoft Access
Alison Dalter gives an in-depbth look at objects, properties, events and methods in Microsoft Access. In this webinar you will learn about using the object browser, referring to objects, working with properties and methods, working with object variables, understanding the ...
Join the Community
Give a Little. Get a Lot.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Answers
In the extended Code 39 repertoire, $K maps to Vertical Tab ($I is Horizontal tab).
But in your font, the symbol associated with $ (at codepoint 0x24) is a double width character which is the equivalent of the pair of characters /D in non-extended mode.
Given the limited examination I've done of the font, I can't see how you'd construct the required symbol from ANY of the available single- or double-width characters in that font.
i.e. your font does not appear to include a complete extended Code 39 repertoire.
If you use the 'standard' FRE3of9 font (instead of the extended 'FRE3of9X' one), I think that you should be able to obtain a horizontal tab barcode symbol, using the character pair $I (and the vertical tab using $K).
The downside to using this font is that you can only 'directly' use the digits, upper-case alphabetics, and the full-stop and hyphen characters; for all other characters, you have to construct a character pair in order to obtain the required symbol, as per the table in the Wiki entry.
For example, to obtain the symbol for lower-case 's', you'd have to select +S (i.e. the plus-sign, followed by upper-case 'S').
And for the Start / Stop character (asterisk (*) in non-extended mode), you'd have to select the character-pair /J.
I have found a barcode I used to use for this which does work. Does this help you get to the answer?
- Tab.jpg
- 2 KB
Code39
>> So I should be able to generate a tab using the 3 of 9 non extended set?
Yes
>> Can you tell me the characters to use / sequence?
It depends on the font; it doesn't appear to be possible using your 'FRE3of9X' font, but (as I said in my comment on 2008-09-03), using the 'FRE3of9' font you can use $I for horizontal tab, or $K for vertical tab.
But you'd also have to transform other characters, which you wouldn't have had to do with the 'FRE3of9X' font.
The WIKI article tells you what replacement characters are required.
>> I have found a barcode I used to use for this which does work. Does this help you get to the answer?
No, because it tells me nothing about what characters and mappings are present in the font.
I think that you just need the string
*USERNAME$KPASSWORD*
as shown in the attached image.
Note that if you want lowercase characters, you have to present these as the upper-case equivalent, preceded by a + symbol (e.g. +K for k).
I don't have a scanner available, hence am unable to verify the barcode samples shown.
I assume that you would have to set a reader to intepret the barcode as extended-Code39, rather than as standard-Code39.
I've just realised that one of my earlier comments, where I stated:
"... And for the Start / Stop character (asterisk (*) in non-extended mode), you'd have to select the character-pair /J."
was somewhat misleading.
The Start/Stop character is unchanged: use the * character (0x2A) to select it.
But if you actually want an asterisk character in your extended-ASCII barcode, you'd need to select it as /J.
- USERNAME.png
- 11 KB
Barcode sample
jware09
The font is one that I created (using the High-Logic FontCreator application) for use within the company I work for, and for customers of our applications.
For that reason, I can't provide it to others, sorry.
If you have a standard Code 39 font, it's relatively straightforward (albeit somewhat tedious) to modify each glyph to include the human readable text.
Note that if this font is used for 'extended-Code39' barcodes, the human readable text will show the individual characters of each character pair used to produce the barcode (e.g. it will show '+K', which a scanner in extended mode will (hopefully) interpet as 'k').
So if you wanted human readable text with the extended set, you'd really need a font which mapped all of the 128 possible ASCII characters to individual glyphs; when it comes to control code characters this can be somewhat problematic.
If you don't have a suitable font with human readable text, then you just have to repeat your input string (complete with any 'transforms' of characters outside of the standard 43-character Code39 repertoire) below the barcode, using a suitable text font (Courier New, Arial, OCR-B, etc.) and adjust the size until the 'characters' align.
I trust that this is clearer than mud!
Chris
Thanks I'll give this a try tomorrow. The maddening thing is that I once did this and had it working for our last deployment but I've lost the original Excel document ! I'm using this on a symbol LS2208 and a RF3090 HHT.
If this doesn't work do I consider using code128 or some other symboly? I have over a hundred users so I need something I can cut and paste the usernames and passwords into just prior to go live. Happily that is 7 weeks away.
Unless I have a fundamental misunderstanding of the extended-Code39 mechanism (which is possible, as I've only ever used the standard repertoire), I think that the fact that the barcodes scanned as:
USERNAME$KPASSWORD
indicates that your scanner is expecting only a standard Code-39 barcode, and is interpreting it as such.
Therefore you need to configure your scanner to interpret barcodes as Extended-Code39 ones; I've no idea if the LS2208 supports this.
... and another point:
I don't think that NotePad 'understands' the Vertical Tab control code:
- if you have a file which already contains such a character, NotePad will probably just show it a as a 'rectangle'.
- if you attempt to include such a character via 'Alt' + (NumPad) 0011, nothing will happen.
WordPad understands a bit more:
- if you have a file which already contains such a character, WordPad will react to it, and tab downwards.
- if you attempt to include such a character via 'Alt' + (NumPad) 0011, nothing will happen.
Word understands it better:
- if you have a file which already contains such a character, Word will react to it, and tab downwards.
- if you attempt to include such a character via 'Alt' + (NumPad) 0011, you'll get a downward tab.
All of the above three applications understand and react to the Horizontal Tab character ('Tab' key, or 'Alt' + (NumPad) 0009).
The barcode must be a Code 39 barcode, not a Code 39 Extended or Full ASCII barcode. The Enable Code 39 Full ASCII must be scanned from the Symbologies section of the LS2208 Product Reference Guide (page 186 of 342). The Enable Function Key Mapping barcodes would have to be scanned if you are seeing something other than the tab happen when you scan into your application. In Word, for instance you will see the italics enable/disbled whenever the $I is encountered in the barcode.
As for the Covert to Code 39 Full ASCII- that is for Wand and Scanner emulation. The setting was having no effect because you were not connecting to either of these hosts.
3 Ways to Join
Business Accounts
- Perfect for organizations
- Multiple users
- Save over 36%
- Create a Business Account
Answer for Membership
- Earn free access
- Showcase your knowledge
- No credit card required
- Sign Up to Answer
Loading Advertisement...
by: DansDadUKPosted on 2008-09-03 at 06:48:56ID: 22377130
After a cursory examination, I don't think that your font contains a glyph which has the appropriate bar-space combination.
If you had an ordinary non-extended font, you could make up all of the extra ASCII characters using combinations of the glyphs for A-Z, preceded by the glyph for %, $, /, or +, as appropriate; but the symbols for some other non-extended characters (like $) have then also to be treated as composites (so $ is represented by the character pair /D) - see the Code 39 Wiki entry http://en.wikipedia.org/wi
But your font, being an extended font, already has most of the extra symbols as double-width, and this also applies to the symbol mapped to codepoint 0x24 for the dollar - so you couldn't use this as the first in a pair to try to represent horizontal tab (as $I).
The appropriate non-extended symbol for $ IS present in the font, as glyph 43, but it is not mapped, so it is not accessible.