Removing Parentheses From Scanned Barcode Follow

0
Avatar
Legacy Poster

I need to create a Code 39 bar code that links two fields, one numeric and one that's simply a letter in parentheses--(Q) or (P), for instance--but I need the alpha field to scan without the parentheses. Does anyone know if this is possible in Bartender, or do I need to create an invisible, non-printing field with just the letter, and link that one to the barcode instead? Thanks much.

 

ps I guess I should mention that the the parentheses are currently scanning as zeros, for whatever reason.

7 comments

0
Avatar
Legacy Poster
Comment actions Permalink

Well first of all, the parenthesis are showing up as zeroes because Code 39 doesn't support encoded parenthesis.

 

If you're asking how to have the human readable show you something other than what is encoded in the barcode, you may use the "Character Template"

(See my attachment for an example).

[attachment=1501:Character Template.JPG]

 

If you're asking how to filter out parenthesis from your barcode, you can use the "Search and Delete" transform

(see my other attachment)

[attachment=1502:Search and Delete.JPG]

0
Avatar
Legacy Poster
Comment actions Permalink

Thanks for your help. I actually don't need a readable for the barcode, but the field with a letter in parentheses needs to be visible on the label. For some reason Easy Label (which we are transitioning from) simply ignored the parentheses without replacing them with a zero. Unfortunatly the "Search and Delete" approach works too well--it removes the parentheses from the data source itself as well as the scanned barcode. Guessing I may have to create an invisible field with only the letter and link that to the barcode....

0
Avatar
Legacy Poster
Comment actions Permalink

just to clarify, here's a pic. in the "PO Number" field I need the barcode, when scanned, to read "R4295751" instead of "0R04295751."

 

 

 

[attachment=1503:Untitled.png]

0
Avatar
Legacy Poster
Comment actions Permalink

The picture helps me realize what's going on. I would manually set up the barcode then with a "Prefix" of "R" (Found again under the transforms tab). Or just add another Embedded Data source prior to your current data that only holds a "R"

 

If it's super important that it be actually linked to the "( R )" data field, then yes, there would be ways to script that to remove the parenthesis only in the barcode but not in the printed text - but it may just be easier to set up the barcode with a prefix.

0
Avatar
Legacy Poster
Comment actions Permalink

Thanks for your help, nRyder. I tried the prefix thing but unfortunately it also adds an R in the data source--so the PO field ends up as "R4295751" instead of just "4295751." Adding another data field with just an "R" seems to be what I may have to do, but it just seems clunky and unnecessary--if anyone knows a simple script that would remove the parentheses in the barcode only, it would be greatly appreciated. Thanks!

0
Avatar
Legacy Poster
Comment actions Permalink

Thanks for your help, nRyder. I tried the prefix thing but unfortunately it also adds an R in the data source--so the PO field ends up as "R4295751" instead of just "4295751." Adding another data field with just an "R" seems to be what I may have to do, but it just seems clunky and unnecessary--if anyone knows a simple script that would remove the parentheses in the barcode only, it would be greatly appreciated. Thanks!

 

The VB script for this data source would look like as follows, assuming the data source name of the "( R )" field is "RPrefix", your VB script would look like:

 

 

value = replace(replace(RPrefix, "(", ""), ")", "")
 
0
Avatar
Legacy Poster
Comment actions Permalink

Thanks for your help NRyder. I hadn't realized you could add an Embedded data source without a text field so I misunderstood one of your suggestions above, which totally worked. All the best!

Please sign in to leave a comment.