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
@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' LIKE %[^A-Za
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
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 does seem to work. Sorry to have lead
everyone astray. Not sure what I
It works for me. Here is the test Active Link on ARS 7.6.04.
Thanks
Mahesh
-- Forwarded message --
From: *Kemes, Lisa* lisa.ke...@te.com
Date: Wed, Jun 15, 2011 at 12:36 PM
Subject: Re: Character String Check
To: arslist@arslist.org
I spoke too soon. Looks like
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
-
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 string in the field is
alphanumeric
**
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
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 either.
I've tried a bunch of workflow
'Field' LIKE %[^A-Za-z0-9-_]%
Thanks
Mahesh
On Tue, Jun 14, 2011 at 1:30 PM, Kemes, Lisa lisa.ke...@te.com 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
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 your
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(ARSList)
[mailto:arslist@ARSLIST.ORG
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
@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-9a-zA-Z\-][0-9a-zA-Z\-][0-9a-zA-Z\-][0-9a-zA-Z\-][0-9a-zA-Z\-][0-9a-zA-Z
: 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 this with an active
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 your
case
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
Something like this is where I usually take advantage of the Oracle
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 Check
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 ### correct?
Lisa
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 'Display Only Temp Field' != $NULL$
ActionShow Error
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 System discussion list(ARSList
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
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
-Original Message-
From: Kemes, Lisa
Sent
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
-
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 versions of Oracle which I think
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
To: arslist@ARSLIST.ORG
Subject: Re: Character String Check
26 matches
Mail list logo