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:[email protected]] On Behalf Of LJ LongWing Sent: Tuesday, June 14, 2011 3:09 PM To: [email protected] 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:[email protected]] On Behalf Of Kemes, Lisa Sent: Tuesday, June 14, 2011 12: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]<mailto:[email protected]> MS 161-43 P.O. Box 3608 Harrisburg, PA 17105-3608 [cid:[email protected]]<http://www.te.com/> www.te.com<http://www.te.com/> [cid:[email protected]]<http://twitter.com/teconnectivity>[cid:[email protected]]<http://www.facebook.com/teconnectivity>[cid:[email protected]]<http://www.flickr.com/photos/teconnectivity/>[cid:[email protected]]<http://www.linkedin.com/groups?gid=1591657>[cid:[email protected]]<http://www.youtube.com/teconnectivity> _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"
<<inline: image001.gif>>
<<inline: image002.png>>
<<inline: image003.png>>
<<inline: image004.png>>
<<inline: image005.png>>
<<inline: image006.png>>
