maiton.vang Posted February 14, 2008 Posted February 14, 2008 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."
comment Posted February 14, 2008 Posted February 14, 2008 Try: "*" & Substitute ( OrderNumber ; "-" ; "" ) & "*"
maiton.vang Posted February 14, 2008 Author Posted February 14, 2008 (edited) 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, 2008 by Guest
comment Posted February 14, 2008 Posted February 14, 2008 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 , "-" , "" ) & "*"
maiton.vang Posted February 14, 2008 Author Posted February 14, 2008 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
comment Posted February 14, 2008 Posted February 14, 2008 Are ALL PO numbers in the same format "01-123456-1" (2 digits, dash, 6 digits, dash, 1 digit)?
maiton.vang Posted February 14, 2008 Author Posted February 14, 2008 (edited) 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, 2008 by Guest
comment Posted February 14, 2008 Posted February 14, 2008 Try: "*" & Left ( Substitute ( OrderNumber , "-" , "" ) , 8 ) & "*"
maiton.vang Posted February 14, 2008 Author Posted February 14, 2008 (edited) 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, 2008 by Guest
comment Posted February 14, 2008 Posted February 14, 2008 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).
maiton.vang Posted February 14, 2008 Author Posted February 14, 2008 got it to work i change the + sign to a & "*" & Left( Substitute( Job Type & Job Number , "-" , "" ) , 8 ) & "*" thank you again for all your help!
Recommended Posts
This topic is 6128 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now