I'm trying to set up a barcode using barcode 3/9 fonts. I would like my calculation to read from my purchase order number. for example: my purchase order number is 01-556792 and i would like my barcode to read 01556792 without dash.

Also in order to create a field using my purchase order number field i need to an asterick "*" before and after the number to make the scanner work! the error i get is "A number, text constant, field name, or "(" is expected here."

Try:

"*" & Substitute ( OrderNumber ; "-" ; "" ) & "*"

Thank you for the fast respond but this is the message i get when i copied and paste the code.

see attached file!

Edited February 14, 200818 yr by Guest

Which version of Filemaker are you using?

Filemaker 6.0

Don't you think that is something worth mentioning? Your profile says 8, and there is no indication in your original post to say otherwise.

I believe this should work for you:

"*" & Substitute ( OrderNumber , "-" , "" ) & "*"

GREAT! THANK YOU NOW IT WORKS

But I did forget to mention that we would like to remove the last digit.

For example our original PO# 01-556792-1 and we would like the barcode to read "01556792" ONLY remove both dashes adn the last digit after the second dash.

This is also in FM 6.0

Are ALL PO numbers in the same format "01-123456-1" (2 digits, dash, 6 digits, dash, 1 digit)?

YES!

OR UNLESS THEY ARE

01-123456-A

IT COULD BE A LETTER FROM A-Z

OR IT COULD BE A LETTER FROM 1-9

Edited February 14, 200818 yr by Guest

Try:

"*" & Left ( Substitute ( OrderNumber , "-" , "" ) , 8 ) & "*"

AWESOME!

THANK YOU SO MUCH FOR YOU HELP TODAY!

Now...that we got our purchase order # to work.

We would also like our job#. For example our job number has to 2 fields

1st field are letters: P, C, X, M, CR

2nd field are numbers: 12345 (5 digits)

for Example our job # are C40354

we would like to create a barcode indicating C40354

this is what i have for the calculation but i got the 2nd fields not teh 1st field which are the letters.

[color:red]"*" & Left( Substitute( Job Type + Job Number , "-" , "" ) , 8 ) & "*"

Also the 1st field for Job Type is a drop down option of:P, C, X, M, CR

[color:black]this is still in FM6

Edited February 14, 200818 yr by Guest

Here's my suggestion: sit down with you already have and with the help file, and figure out how it works. Then you will be able to apply it to your next question (and the one after next).

got it to work

i change the + sign to a &

"*" & Left( Substitute( Job Type & Job Number , "-" , "" ) , 8 ) & "*"

thank you again for all your help!