Bar code in Crystal for field containing blanks

Yahoo Archive
1
We discovered that our scanner was not set to use the extended Code 39 fonts.  We are now using the free3of9 font with the scanner reset to allow the extended Code 39 font.  There is still some working around the font size, and the size and position of the bar code on the report, but this does create a bar code that can be scanned and it appropriately scans fields with blanks.  When scanned, we now have the actual contents of the field.
Scanner:  Intermec SR30.  Had to set the scanner to work with the Code 39 - format - full ASCII (extended).
2

We use Crystal Reports developer XI for modifying/creating reports to be used in EPICOR 905.  Bar code font 39 from DataWorks has been added to every computer.


We need to print a field that contains one or more blank spaces as a bar code that can be scanned.


Example:  Tracking Number field with the data: The Customer Picked Up

Example: Tracking Number field with the data:  1Z 3445 920 11111

Example:  Part Number field that not only contains spaces, but also starts with a blank space


What formula or syntax is required?


We are using this formula:  If NOT IsNull({shiphead.TrackingNumber}) then "*"&({Shiphead.TrackingNumber})&"*" else ""


The resulting bar code for the data:  *194 423 584* displays a bar code with spaces in the bar code, and it cannot be scanned.


Any help would be appreciated.

3
Will this work?  

if(mid({@bc_text},2,1) = "Z") THEN 
    "*" & replace({@bc_text}," ", "") & "*" 
ELSE  
    "*"&{@bc_text}&"*"

Calvin



 

4
One more thing ...  Spaces will create a space in the code.  replace them with the undersocre.

So the above code should have been

if(mid({@bc_text},2,1) = "Z") THEN 
    "*" & replace({@bc_text}," ", "") & "*" 
ELSE  
    "*"& replace({@bc_text}," ","_")&"*"

* the field {@bc_text}  was just a formula I used to test it.
5
We are not trying to replace characters with a blank/space in the bar code.  We are trying to get the bar code to scan with the same information that comes from the field, which may contain spaces in any position in the field, and which may contain more than one space in the field.

Example:  Tracking Number:  1Z 22222 33333 22 6666
Example:  PO Number:   144 56K
Example:  Part Number:  12 33366 1/4 13445

When the bar code is scanned, it should be the same information that is contained in the field.

Can a bar code be used for strings of text that also contain spaces?  We want to be able to reduce human error by ensuring that all information is scanned exactly as entered into the system to then be used for updating for receiving.
6

Does this help at all?

 

http://www.idautomation.com/kb/fonts-space.html

 

Do you have any purchased barcode libraries? If so which ones?

 

 

Joshua Giese
Technology Solutions : CXO

Direct Phone:    920.593.8299
Office Phone:    920.437.6400 x342

http://wcibags.com/email/emailFooter4.jpg

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, June 3, 2016 10:53
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Bar code in Crystal for field containing blanks

 

 

We are not trying to replace characters with a blank/space in the bar code.  We are trying to get the bar code to scan with the same information that comes from the field, which may contain spaces in any position in the field, and which may contain more than one space in the field.

 

Example:  Tracking Number:  1Z 22222 33333 22 6666

Example:  PO Number:   144 56K

Example:  Part Number:  12 33366 1/4 13445

 

When the bar code is scanned, it should be the same information that is contained in the field.

 

Can a bar code be used for strings of text that also contain spaces?  We want to be able to reduce human error by ensuring that all information is scanned exactly as entered into the system to then be used for updating for receiving.

7
The bar codes we use were obtained from Epicor - DataWorks Bar 39.

It appears that DataWorks Bar 39 does not resolve the use of a space in the field - cannot translate that to a bar code that can scan and output the correct field information if there is a space in the field.

8

No it’s just a plain old 3of9. You would need some other library integrated with crystal that can support the anything not alphanumeric. Typically listed as a Full ASCI. IDAutomation is typically the go-to for crystal. 2D is usually the way I go when I need special characters a lot less hassle. PDF417 and QR are great for strings. However that comes with necessity of 2D scanners.

 

Couple different avenues you can take all of them cost $$’s

 

Joshua Giese
Technology Solutions : CXO

Direct Phone:    920.593.8299
Office Phone:    920.437.6400 x342

http://wcibags.com/email/emailFooter4.jpg

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, June 3, 2016 13:23
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Bar code in Crystal for field containing blanks

 

 

The bar codes we use were obtained from Epicor - DataWorks Bar 39.

 

It appears that DataWorks Bar 39 does not resolve the use of a space in the field - cannot translate that to a bar code that can scan and output the correct field information if there is a space in the field.

 

9
The text "HELLO WORLD 123"  printed in a 3of9 Font will look like the following pseudo barcode

HELLO WORLD 1234

Printing  "HELLO_WORLD_123" will give

HELLOWORLD1234
 
Scanning the latter will return "HELLO WORLD 123"