It works for me. Here is the test Active Link on ARS 7.6.04.
Thanks Mahesh ---------- Forwarded message ---------- From: *Kemes, Lisa* <[email protected]> Date: Wed, Jun 15, 2011 at 12:36 PM Subject: Re: Character String Check To: [email protected] I spoke too soon. Looks like this works very well with a filter, but not an active link. When I type in SDEX-WW-D-QUOTE-QLIKVIEW-FTP my active link is giving me an error, but my filter is putting it through. I need this to work on an Active Link.....Bummer..... Back to the Translate solution.... Lisa -----Original Message----- From: Action Request System discussion list(ARSList) [mailto: [email protected]] On Behalf Of Kemes, Lisa Sent: Wednesday, June 15, 2011 12:26 PM To: [email protected] Subject: Re: Character String Check Thanks Misi, I just tried this again and it does seem to work. Sorry to have lead everyone astray. Not sure what I was doing wrong the first time around. This works just as well too! Lisa -----Original Message----- From: Action Request System discussion list(ARSList) [mailto: [email protected]] On Behalf Of Misi Mladoniczky Sent: Wednesday, June 15, 2011 5:41 AM To: [email protected] Subject: Re: Character String Check Hi, I just want to say that Mahesh suggestion is definitely the way to go. The FLTR-Run-If (with a possible ACTL-shadow) should read: ('Field' LIKE "%[^A-Za-z0-9-_]%") And then give you an appropriate error message. This should work on any DB, as it has nothing to do with the database, it is evaluated internally within the AR System. The initial ^ is the negator (NOT) character. This is not the same thing as (NOT 'Field' LIKE "%[A-Za-z0-9-_]%"), as this would first find a match of the characters, and then negate it. In the example "?A?" it would find the "A" and then negate it. In the first suggestion above though it would find the first "?", which is a bad character. In other words the format [^...] is the only way to go. The only thing I am not sure about is the dash-character (-), as it specifies a range... You could try "%-_A-Za-z0-9]%" instead. Others have suggested a backslash, but I do not think that will work here... Try removing the dash altogether to see if you can get the rest to work at least. Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. > 'Field' LIKE "%[^A-Za-z0-9-_]%" > > Thanks > Mahesh > > > On Tue, Jun 14, 2011 at 1:30 PM, Kemes, Lisa <[email protected]> wrote: > >> ** >> >> 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 >> >> [image: Description: >> http://www.tycoelectronics.com/images/socialmedia/smallTElogo.gif]<ht >> tp://www.te.com/> >> www.te.com >> >> >> [image: Description: >> http://www.tycoelectronics.com/images/socialmedia/twitter.png]< http://twitter.com/teconnectivity>[image: >> Description: >> http://www.tycoelectronics.com/images/socialmedia/facebook.png]< http://www.facebook.com/teconnectivity>[image: >> Description: >> http://www.tycoelectronics.com/images/socialmedia/flickr.png]< http://www.flickr.com/photos/teconnectivity/>[image: >> Description: >> http://www.tycoelectronics.com/images/socialmedia/linkedin.png]< http://www.linkedin.com/groups?gid=1591657>[image: >> Description: >> http://www.tycoelectronics.com/images/socialmedia/youtube.png]<http:/ >> /www.youtube.com/teconnectivity> >> >> >> _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" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
<<image001.png>>
<<image002.png>>
