hi mark, wildcard [^] will matches any character not with in the specified range, [^0-9] means it will check the range from 0 to 9 not the other characters.But u r requirement is "anythig but not the numbers" to meet u r requirement use [-] wildcard instead of [^].
run if:'Character Field' LIKE "%[0-9]%" Regards, Ashraf sultana. Mark Milke wrote: > > Hi there, > > I'm trying to test if a Character Field contains anything but numbers. > I did a test form on that I have a character field and a button. When > I click the button, it fires an Active Link with this RunIf: > > 'Character Field' LIKE "[^0-9]" > > If the RunIf is true, the Active Link shows an error message. > > Here's my test. > > 1. when I enter "1" into the character field and click the button I > get NO message so OK > 2. when I enter "19" into the character field and click the button I > get NO message so OK > 3. when I enter "a" into the character field and click the button I > get THE message so OK > > 4. when I enter "a2" into the character field and click the button I > get NO message and this is NOT OK > > What's wrong with the case 4? > > I thought I've said 'Character Field' LIKE "[^0-9]" which mean, if the > field contains anything but the the numbers from 0 to 9, the Run If is > TRUE and this should cause the error message. As far as I'm concerned > a2 isn't within 0-9, so where is there error message? What am I > missing? > > > Mark > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where > the Answers Are" > > -- View this message in context: http://www.nabble.com/wilrdcard-problem-tf4479399.html#a12774732 Sent from the ARS (Action Request System) mailing list archive at Nabble.com. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
