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 TopicsHow 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.
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.
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.
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.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.

Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
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.
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.
>> 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.
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.
Business Accounts
Answer for Membership
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.
ki/Code_39 for details.
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.