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 ... I checked one of mine and it should be (Returns added here for
readability)
Select Replace(TRANSLATE('$Field$',
'ABCDEFGHIJKLMNOPQRSTUVWXYZ-0123456789_abcdefghijklmnopqrstuvwxyz',
'----------------------------------------------------------------'),'-','')
from DUAL
There is an odd thing about Translate on some versions of Oracle... It wants
the same number of characters in both strings
Fred
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, 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 'Display Only Temp Field' != $NULL$
Action Show Error Message
Fred
-----Original Message-----
From: 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 ### correct?
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
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). If there any characters left over then in a
second filter I show an error.
SQL Set Fields
Select TRANSLATE('$Field$',
'ABCDEFGHIJKLMNOPQRSTUVWXYZ-0123456789_abcdefghijklmnopqrstuvwxyz','') from
DUAL
In pure Remedy you could do a series of replacements to remove each
character and that will do the same thing.
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 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
lisa.ke...@te.com
MS 161-43
P.O. Box 3608
Harrisburg, PA 17105-3608
www.te.com
_______________________________________________________________________________
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"
_______________________________________________________________________________
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"
