Inside ARS itself you have the standard REPLACE, SUBSTR, STRSTR type of
commands. Depending on what database you are using you can leverage
it's regular expressions ability.
i.e. Using Oracle 10 if I want to strip all punctuation characters from
a character field (we will call it zStrTemp) and replace it with a space
I can do the following in a Set Fields from SQL action:
Select RegExp_REPLACE('$zStrTemp$','([[:punct:]])',' ') from Dual
This will work in all Active Links, Filters, Escalations
Fred
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of SUBSCRIBE arslist Neel
Sent: Thursday, May 17, 2007 8:36 AM
To: arslist@ARSLIST.ORG
Subject: Regular Expressions in AR 7.0.01
Hello fellow listers,
In application we use, we have an extensive use of email in our
application and I want to make sure that users are entering valid email
addresses as we have about 5-10 email errors/day with users entering
invalid email address (with special characters or white-space in
email-address). Is it possible to use regular expressions with ARs? If
anyone could provide some examples, that would be awesome.
Thank you,
Neel Gautam.
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
