Hae you tried this. Run If: 'Field' LIKE "%[^A-Za-z0-9-_]%"
If Actions: Message Thanks Mahesh On Tue, Jun 14, 2011 at 4:37 PM, Kemes, Lisa <[email protected]> wrote: > I tried this as well, and not sure why, but q### is returning nothing. > > It should return ### correct? > > Lisa > > > -----Original Message----- > From: Action Request System discussion list(ARSList) [mailto: > [email protected]] On Behalf Of Grooms, Frederick W > Sent: Tuesday, June 14, 2011 2:58 PM > To: [email protected] > Subject: Re: Character String Check > > Something like this is where I usually take advantage of the Oracle > database's TRANSLATE function. I do a set fields (to a Display only field) > translating all letters and numbers to nothing (as well as hyphen and > underscore in your case). If there any characters left over then in a > second filter I show an error. > > SQL Set Fields > Select TRANSLATE('$Field$', > 'ABCDEFGHIJKLMNOPQRSTUVWXYZ-0123456789_abcdefghijklmnopqrstuvwxyz','') from > DUAL > > > In pure Remedy you could do a series of replacements to remove each > character and that will do the same thing. > > Fred > > > -----Original Message----- > From: Action Request System discussion list(ARSList) [mailto: > [email protected]] On Behalf Of Kemes, Lisa > Sent: Tuesday, June 14, 2011 1:31 PM > To: [email protected] > Subject: Character String Check > > ** > I need to check a character field to make sure that the string in the field > is alphanumeric and the only special characters that are allowed are a > hyphen "-" or an underscore. No spaces allowed either. > > I've tried a bunch of workflow and it's just not working for me. > > > Lisa Kemes > AR System Developer > TE Information Systems > Global Infrastructure and Ops > +01 717 810 2408 tel > +01 717 602 9460 mobile > [email protected] > MS 161-43 > P.O. Box 3608 > Harrisburg, PA 17105-3608 > > > www.te.com > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 > www.wwrug.com ARSList: "Where the Answers Are" > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
