Thanks for your suggestions Fred & Rod.
> Date: Fri, 29 Jan 2010 08:26:26 -0600
> From: [email protected]
> Subject: Re: Help with Filter Functions
> To: [email protected]
>
> 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:[email protected]] On Behalf Of Rod Harris
> Sent: Thursday, January 28, 2010 9:23 PM
> To: [email protected]
> 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 <[email protected]>:
> > **
> >
> > 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:[email protected] 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:[email protected] ARSlist: "Where the Answers Are"
