Thanks for your suggestions Fred & Rod.
> Date: Fri, 29 Jan 2010 08:26:26 -0600
> From: frederick.w.gro...@xo.com
> Subject: Re: Help with Filter Functions
> To: arslist@ARSLIST.ORG
>
> Another option is to use the capabilities of your database. For instance on
> Oracle you could use a SQL Set Fields with a regex type of statement.
>
> Fred
>
> -----Original Message-----
> From: Action Request System discussion list(ARSList)
> [mailto:arsl...@arslist.org] On Behalf Of Rod Harris
> Sent: Thursday, January 28, 2010 9:23 PM
> To: arslist@ARSLIST.ORG
> Subject: Re: Help with Filter Functions
>
> Hi Kevin,
>
> You have found correctly that the string functions don't support
> wildcards/regular expression functionality. The [a-z] wildcard is
> supported by the LIKE operator however. You can create a simple loop
> via a filter guide to move through the string until you come across a
> matching lowercase letter, then exit the loop and the number of
> iterations is the position of the character.
>
> Rod
>
> 2010/1/29 Kevin Thornley <kevin.thorn...@hotmail.com>:
> > **
> >
> > All
> >
> > I trying to create a filter set fields action that finds the first lowercase
> > letter in a field and returns the location.
> >
> > I attempted the qualification below but it keeps putting quotes around the
> > [a-z]
> >
> > STRSTR($Testing 1$, "[a-z]")
> >
> > Is this possible or is there another approach that would work ?
> >
> > Thanks
> > Kevin
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
_________________________________________________________________
Hotmail: Free, trusted and rich email service.
http://clk.atdmt.com/GBL/go/196390708/direct/01/
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
