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
>
> ________________________________
> Your E-mail and More On-the-Go. Get Windows Live Hotmail Free. Sign up now.
> _Platinum Sponsor: [email protected] ARSlist: "Where the Answers
> Are"_

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"

Reply via email to