View Full Version : Spaces, underlines and dashes


teiben
05-01-2007, 04:55 AM
I have a db, that I used to maintain as a end user, now it's in a multiuser environment, problem is the user has to enter job numbers.
Below are all valid job numbers, therefore a mask will not work.
So I was thinking "HOW" could this be done, perhaps eliminating Spaces, underlines and dashes from this field. How would I do this on the same field for all 3 conditions (course i would have to backtrack)

01-AB134
02-091
2-2177
3-715
03-021-A
05-001-PBPL
07-07-955

neileg
05-01-2007, 05:14 AM
Are you saying that spaces and underlines are invalid, but dashes are OK?

teiben
05-02-2007, 06:26 PM
spaces, dashes and underlines are invalid, how does one validation for these 3 conditions

neileg
05-03-2007, 02:26 AM
I'm sorry, I don't understand. Your sample job numbers have dashes in them, but you're saying that dashes are invalid. Do you want to allow the user to enter the job number with the dashes and then strip them out, or do you want to prevent the dashes being input, or what?

RoyVidar
05-03-2007, 09:09 AM
Try a validation rule of
Not Like "*[-_ ]*"