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
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
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
@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
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
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
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
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
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
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
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
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
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
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
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
: 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
**
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
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-
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
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
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
'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
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
**
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 "%#%
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
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
26 matches
Mail list logo