Re: Character String Check

2011-06-15 Thread Mahesh
It works for me. Here is the test Active Link on ARS 7.6.04. Thanks Mahesh -- Forwarded message -- From: *Kemes, Lisa* Date: Wed, Jun 15, 2011 at 12:36 PM Subject: Re: Character String Check To: arslist@arslist.org I spoke too soon. Looks like this works very well

Re: Character String Check

2011-06-15 Thread Misi Mladoniczky
nal Message- > From: Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa > Sent: Wednesday, June 15, 2011 12:26 PM > To: arslist@ARSLIST.ORG > Subject: Re: Character String Check > > Thanks Misi, > > I just tried this aga

Re: Character String Check

2011-06-15 Thread Kemes, Lisa
solution Lisa -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Wednesday, June 15, 2011 12:26 PM To: arslist@ARSLIST.ORG Subject: Re: Character String Check Thanks Misi, I just tried this again and it

Re: Character String Check

2011-06-15 Thread Kemes, Lisa
@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: Wednesday, June 15, 2011 5:41 AM To: arslist@ARSLIST.ORG 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' LIK

Re: Character String Check

2011-06-15 Thread Misi Mladoniczky
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 eva

Re: Character String Check

2011-06-14 Thread Joe Martin D'Souza
happening is if even a single character is TRANSLATE'ed to NULL the whole string gets set to NULL.. so it doesn't matter what characters follow that.. Joe -Original Message- From: Kemes, Lisa Sent: Tuesday, June 14, 2011 5:57 PM Newsgroups: public.remedy.arsystem.general

Re: Character String Check

2011-06-14 Thread Grooms, Frederick W
ed -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Tuesday, June 14, 2011 4:56 PM To: arslist@ARSLIST.ORG Subject: Re: Character String Check That was a limitation in some earlier versio

Re: Character String Check

2011-06-14 Thread Kemes, Lisa
This WORKS!! Thank you thank you thank you! Lisa -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Tuesday, June 14, 2011 5:53 PM To: arslist@ARSLIST.ORG Subject: Re: Character String Check

Re: Character String Check

2011-06-14 Thread Kemes, Lisa
PM To: arslist@ARSLIST.ORG Subject: Re: Character String Check Yes it should have.. did you try it on a SQLPlus window to see what it returns? Select TRANSLATE('q###', 'ABCDEFGHIJKLMNOPQRSTUVWXYZ-0123456789_abcdefghijklmnopqrstuvwxyz','') from DUAL; What do you get? Joe

Re: Character String Check

2011-06-14 Thread Joe Martin D'Souza
That was a limitation in some earlier versions of Oracle which I think are removed now? Joe -Original Message- From: Grooms, Frederick W Sent: Tuesday, June 14, 2011 5:53 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Character String Check Sorry

Re: Character String Check

2011-06-14 Thread Joe Martin D'Souza
t: Tuesday, June 14, 2011 5:37 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Character String Check I tried this as well, and not sure why, but q### is returning nothing. It should return ### correct? Lisa -Original Message- From: Action Request

Re: Character String Check

2011-06-14 Thread Grooms, Frederick W
oms, Frederick W Sent: Tuesday, June 14, 2011 4:48 PM To: arslist@ARSLIST.ORG Subject: Re: Character String Check No ... It returns the list of bad characters found (so if anything is left over then you can show then what characters they entered that were bad) The 2nd AL Run-If 'Displ

Re: Character String Check

2011-06-14 Thread Grooms, Frederick W
om: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Tuesday, June 14, 2011 4:37 PM To: arslist@ARSLIST.ORG Subject: Re: Character String Check I tried this as well, and not sure why, but q### is returning nothing. It should return ### corr

Re: Character String Check

2011-06-14 Thread Kemes, Lisa
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

Re: Character String Check

2011-06-14 Thread Mahesh
t; Lisa > > > -Original Message- > From: Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W > Sent: Tuesday, June 14, 2011 2:58 PM > To: arslist@ARSLIST.ORG > Subject: Re: Character String Check > > So

Re: Character String Check

2011-06-14 Thread Kemes, Lisa
: 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

Re: Character String Check

2011-06-14 Thread Grooms, Frederick W
: Re: Character String Check ** 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

Re: Character String Check

2011-06-14 Thread Kemes, Lisa
sa 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-

Re: Character String Check

2011-06-14 Thread Frank Caruso
ARSLIST.ORG] *On Behalf Of *LJ LongWing > *Sent:* Tuesday, June 14, 2011 3:09 PM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: Character String Check > > > > ** > > I would try something like > > > > NOT (‘Field’ LIKE “%[0-9a-zA-Z\-]%”) > > > > Tha

Re: Character String Check

2011-06-14 Thread Kemes, Lisa
day, June 14, 2011 3:09 PM To: 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(A

Re: Character String Check

2011-06-14 Thread Joe Martin D'Souza
To: 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

Re: Character String Check

2011-06-14 Thread Mahesh
'Field' LIKE "%[^A-Za-z0-9-_]%" Thanks Mahesh On Tue, Jun 14, 2011 at 1:30 PM, Kemes, Lisa 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 spa

Re: Character String Check

2011-06-14 Thread LJ LongWing
June 14, 2011 12:31 PM To: 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 eit

Re: Character String Check

2011-06-14 Thread Chintan Shah
** Hi Lisa,You can probably use one of the PATTERN at Field Level.Field has properties where you can do a "Pattern" of either "LOWER" or "UPPER" depending on your scenario.Then you will need an Active Link to validate other special characters.e.g. NOT ('Field' LIKE "%$%") AND NOT ('Field' LIKE "%#%

Re: Character String Check

2011-06-14 Thread Grooms, Frederick W
hing. Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Tuesday, June 14, 2011 1:31 PM To: arslist@ARSLIST.ORG Subject: Character String Check ** I need to check a character field to make sure that the s

Character String Check

2011-06-14 Thread Kemes, Lisa
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 Devel