DWBAR 39 Blank Title 112101

Yahoo Archive
1
Vic,
Thanks. Can't believe I haven't run across this before.

Kent Reardon
315-575-8067


From: vic.drecchio@...
To: vantage@yahoogroups.com
CC: k-reardon@...
Subject: RE: [Vantage] DWBAR 39
Date: Thu, 12 Jul 2012 09:18:45 -0400

Check out "Special Barcode Characters.PDF" in http://tech.groups.yahoo.com/group/vantage/files/Barcoding/ In Crystal Reports on that field, you'll need to create a formula, use the REPLACE() function and replace any "_" with a "%O". That's from memory, but double check. And then use that formula in place of the current barcoded Part Number text object in CR. Remember to encapsulate the part number with asterisks. So if your Part Number was: "123_456" Your formula would look something like "*" + REPLACE({Part.Partnum}, "_", "%O") + "*"and it would effectively look like: "*123%O456*" Flip the font of the formula field once you drag it onto your report to DWBar and then it should scan fine. From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of reardon_kent
Sent: Thursday, July 12, 2012 9:09 AM
To: vantage@yahoogroups.com
Subject: [Vantage] DWBAR 39
Ran into an issue with Bar Coding a part number with an imbedded underscored,using Dataworks Bar 39. Instead of bar coding the underscore as part of the text string, a '_' appears within the bar code. Has anyone run into this and found a solution?No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2195 / Virus Database: 2437/5127 - Release Date: 07/12/12No virus found in this message.

Checked by AVG - www.avg.com

Version: 2012.0.2195 / Virus Database: 2437/5127 - Release Date: 07/12/12

[Non-text portions of this message have been removed]
2
Ran into an issue with Bar Coding a part number with an imbedded underscored,using Dataworks Bar 39. Instead of bar coding the underscore as part of the text string, a '_' appears within the bar code. Has anyone run into this and found a solution?
3
Check out "Special Barcode Characters.PDF" in
http://tech.groups.yahoo.com/group/vantage/files/Barcoding/



In Crystal Reports on that field, you'll need to create a formula, use the
REPLACE() function and replace any "_" with a "%O". That's from memory, but
double check.



And then use that formula in place of the current barcoded Part Number text
object in CR.



Remember to encapsulate the part number with asterisks.



So if your Part Number was: "123_456"



Your formula would look something like

"*" + REPLACE({Part.Partnum}, "_", "%O") + "*"

and it would effectively look like: "*123%O456*"



Flip the font of the formula field once you drag it onto your report to
DWBar and then it should scan fine.







From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
reardon_kent
Sent: Thursday, July 12, 2012 9:09 AM
To: vantage@yahoogroups.com
Subject: [Vantage] DWBAR 39






Ran into an issue with Bar Coding a part number with an imbedded
underscored,using Dataworks Bar 39. Instead of bar coding the underscore as
part of the text string, a '_' appears within the bar code. Has anyone run
into this and found a solution?



No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2195 / Virus Database: 2437/5127 - Release Date: 07/12/12




-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2195 / Virus Database: 2437/5127 - Release Date: 07/12/12

[Non-text portions of this message have been removed]
4
You may have to use the ASCii code for the underscore character.

I believe if you google extended ascii codes, you will find the appropriate number.

You will also need to make sure your barcode scanners can read extended 3of9 barcodes.

Hope this helps.

Jason Claggett
Microsoft Small Business Specialist
MCP #3856159
2W Technologies, LLC
312.533.4033 x8039
jason@...<mailto:jason@...>
[cid:image001.jpg@01CD6013.6DCF26F0]

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of reardon_kent
Sent: Thursday, July 12, 2012 9:09 AM
To: vantage@yahoogroups.com
Subject: [Vantage] DWBAR 39



Ran into an issue with Bar Coding a part number with an imbedded underscored,using Dataworks Bar 39. Instead of bar coding the underscore as part of the text string, a '_' appears within the bar code. Has anyone run into this and found a solution?



[Non-text portions of this message have been removed]