Thanks everyone for your help. I think I'll just have to take each character and determine if it fits the "LIKE" criteria. The first character that doesn't fit, I will show an error. I can do this with an active link guide.
I have to do this with an active link because this is a display only form, so I don't think I can do a translate. I also don't think I can do a Like with the underscore because of an Oracle restriction so I'll have to also do a 'field' = "_" as well to see if this fits the criteria or not. Lisa From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Frank Caruso Sent: Tuesday, June 14, 2011 4:17 PM To: arslist@ARSLIST.ORG Subject: Re: Character String Check ** I think you need the REGEX for each character in the string: NOT ('Field' LIKE "%[0-9a-zA-Z\-][0-9a-zA-Z\-][0-9a-zA-Z\-][0-9a-zA-Z\-][0-9a-zA-Z\-][0-9a-zA-Z\-][0-9a-zA-Z\-][0-9a-zA-Z\-]%") Maybe. I did not test it. On Tue, Jun 14, 2011 at 4:13 PM, Kemes, Lisa <lisa.ke...@te.com<mailto:lisa.ke...@te.com>> wrote: ** I tried NOT ('Field' LIKE "%[0-9a-zA-Z\-]%") in run if for my filter and when I tested it I typed a@@@ in the field and it lets it go through..... Lisa From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>] On Behalf Of LJ LongWing Sent: Tuesday, June 14, 2011 3:09 PM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Re: Character String Check ** I would try something like NOT ('Field' LIKE "%[0-9a-zA-Z\-]%") That would be the run-if for a filter throwing an error about incorrect format 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 12: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/> <http://www.te.com/> _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _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"
