Hi,
In that case you should report it as a bug.
You can always create a service call to handle this on the server. I still
think it is better to avoid SQL-coding if possible.
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.
> 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"
