Need help on Code128 and Excel (carriage return and pipe)

General discussion about Morovia barcode fonts, OCR/MICR fonts and postal fonts.

Need help on Code128 and Excel (carriage return and pipe)

Postby pohboonsiang on Tue Oct 27, 2009 2:03 am

I was trying to convert the below string to code128 barcode with human readable text. I used excel function code128ex but could not find the appropriate font type to display both barcode and readable text. The input string contains carriage return (~d013) and pipe ("|").

Input text: |338015391501~d013110110003764011~d0131010~d013088000
If use font MRV Code128M, it will only show me the barcode without text.
If use font MRV Code128cMa, it will show me the barcode with text "9299338015391501 77179910110003764011 77991010 779908800005" instead of "|338015391501 110110003764011 1010 088000".

Please help. Thanks.
pohboonsiang
 
Posts: 2
Joined: Tue Oct 27, 2009 1:52 am

Re: Need help on Code128 and Excel (carriage return and pipe)

Postby glitch on Tue Oct 27, 2009 4:55 pm

When you are doing mixed Code128 character set, you can't get the human readable displayed correctly using the font, because the font can't alter its characters dynamically. You will get the correct result from the barcode.

To work around the problem, you can use the cell below for human readable text.

Or you can use Barcode ActiveX control (http://www.morovia.com/activex/barcode-lite.asp), which fits better in your scenario.
The information above is provided "AS IS", with no warranties, and confers no rights.
User avatar
glitch
Support Engineer
 
Posts: 198
Joined: Wed May 14, 2008 2:42 pm

Re: Need help on Code128 and Excel (carriage return and pipe)

Postby pohboonsiang on Wed Oct 28, 2009 1:48 am

Thanks for the replies. I will use cell below to display human readable text.
pohboonsiang
 
Posts: 2
Joined: Tue Oct 27, 2009 1:52 am

Re: Need help on Code128 and Excel (carriage return and pipe)

Postby 043turning on Mon Jun 07, 2010 2:40 am

I posted this question in another post but closer inspection I see that last date it was used was 2007 so I thought it might be better to post here ....

Hi Guys/Gals, Sorry my first post is a question but I am new to the barcode world and whilst I understand the need to handshaking Error corection and data integaty the software I'm using requires a "Tab"to be inserted at the end of the Data and Whilst I can find many ASCI table that show the code for functions like tab very few barcode generatos allow for the addition of special charators.
I guess my question is can you create a dta field like "19_SQR124-4L"and have a "TAB" included in the string using XLS =Code128A(C2)
043turning
 
Posts: 3
Joined: Sun Jun 06, 2010 11:39 pm

Re: Need help on Code128 and Excel (carriage return and pipe)

Postby glitch on Mon Jun 07, 2010 10:49 am

You can use CONCATENATE function in Excel to combine fields:

Code128A( CONCATENATE("19_SQR124-4L", Chr(9), C2) )
The information above is provided "AS IS", with no warranties, and confers no rights.
User avatar
glitch
Support Engineer
 
Posts: 198
Joined: Wed May 14, 2008 2:42 pm

Re: Need help on Code128 and Excel (carriage return and pipe)

Postby glitch on Mon Jun 07, 2010 10:55 am

I also recommend to use Code128Ex function, instead of Code128A. The former one will produce shorter barcode.

http://mdn.morovia.com/kb/entry/10048/I ... -EAN128Ex/
The information above is provided "AS IS", with no warranties, and confers no rights.
User avatar
glitch
Support Engineer
 
Posts: 198
Joined: Wed May 14, 2008 2:42 pm


Return to General Discussion

Who is online

Users browsing this forum: No registered users and 0 guests