Yes, this doesn't work either unfortunately. It accepts all kinds of characters.....
Lisa From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mahesh Sent: Tuesday, June 14, 2011 5:41 PM To: arslist@ARSLIST.ORG Subject: Re: Character String Check ** 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 <lisa.ke...@te.com<mailto:lisa.ke...@te.com>> 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:arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>] On Behalf Of Grooms, Frederick W Sent: Tuesday, June 14, 2011 2:58 PM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> 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:arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>] On Behalf Of Kemes, Lisa Sent: Tuesday, June 14, 2011 1:31 PM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> 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:%2B01%20717%20810%202408> tel +01 717 602 9460<tel:%2B01%20717%20602%209460> mobile lisa.ke...@te.com<mailto:lisa.ke...@te.com> MS 161-43 P.O. Box 3608 Harrisburg, PA 17105-3608 www.te.com<http://www.te.com> _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org<http://www.arslist.org> attend wwrug11 www.wwrug.com<http://www.wwrug.com> ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org<http://www.arslist.org> attend wwrug11 www.wwrug.com<http://www.wwrug.com> ARSList: "Where the Answers Are" _attend WWRUG11 www.wwrug.com<http://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"
