I think this Run if should get the job done.
'Field' LIKE "%[^-0-9]%"
If you have to you might have to go as far as...
'Field' LIKE "%[^-0123456789]%"
or maybe
'Field' LIKE "%[^0123456789-]%"
( I seem to remember the hyphen need to be first to be understood as
not being a range, but I can not find that in the docs at the moment.)
Read it as:
When the field has a character that is not("^") a hyphen or in the
range([0-9]) of "0 to 9".
That just does not seem like that long of a Run If to me. :)
JMHO: However I would push to not support the hyphen too. they are
silly in a phone number. BTW: open and close parentheses are also
silly. Phone _numbers_ are numbers... not formatting. That is for
reports/display tools to do.
--
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS = Action Request System(Remedy)
Love, then teach
Solution = People + Process + Tools
Fast, Accurate, Cheap.... Pick two.
On Feb 19, 2008 2:01 PM, Shawn Stonequist <[EMAIL PROTECTED]> wrote:
> Greetings List!
>
> This may be a bit strange. We have a form that is used & populated by one of
> our customers. The data is sent electronically to third company.
> Unfortunately, "strange" characters are being entered into the Phone Number
> fields, which is causing an issue. The customer is requesting an error
> message (not a replacement) when anything other than a digit or a hyphen is
> entered.
>
> Does anyone know of a way to do this (other than an extremely long Run If
> qualification that lists every letter and symbol)?
>
> Huge thanks!
> Shawn Stonequist
> EMNS, Inc.
> Remedy 6.3
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
