Re: Wildcard question

[Rocky Rockwell]

** Mark, the only thing I would add to Brian's email is first make UPPER function to make sure the alpha values are in upper case and then to check for the upper case "E" or "I" add it to his replace. Or do do your wildcard with "[EI]". Hope this helps Rocky Rocky Rockwell mgrockw...@verizon.net Ph#1: 325-884-1234 Ph#2: 325-884-1263 Mobile: 325-450-1297 http://www.linkedin.com/in/mgrockwell Brian Bishop wrote: Hi Mark, If you want to make sure that it is a maximum of 8 digits do the following. Do a a/l set fields into an display only integer field of LENGTHC($field name$) Follow it up with a second a/l that has a qualification of integer field is 8 and throws an error message This will allow anything from 0 to 8 characters. If I want to ensure a character field is numeric only I do the following. a/l or filter set fields into a display only char field REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPL ACE($ISSINumber$, "0", ""), "1", ""), "2", ""), "3", ""), "4", ""), "5", ""), "6", ""), "7", ""), "8", ""), "9", "") follow this up with either a second action checking length and if it is greater than 0 there must be other characters beside numeric, or check if it is NULL. The replace will take away all numeric values and if anything is left it can't be purely numeric. For your second problem check if it is E% or I% if it isn't throw an error message. If it is then check if the field is __.% That is two underscores a full stop and then % for anything. All these checks will need to be a NOT 'fieldname' LIKE Brian Bishop Goldstag Consultants Ltd tel: 07973 746832 -----Original Message----- From: Action Request System discussion list(ARSList) __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___