Hi,
I would probably loop through the whole string.
There are several ways to do this, and if the text is not too big, this
could be a way to do it using three filters in a filter-guide.
run-if()
set-fields
tmpStr = $string$
tmpStrDigits = $NULL$
#loop
runif('tmpStr' LIKE "[0-9]%") # starts with a digit
set-fields
tmpStrDigits = $tmpStrDigits$ + SUBSTRC($tmpStr$, 0, 1)
runif('tmpStr' LIKE "_%[0-9]%") # contains more digits
set-fields
tmpStr = SUBSTRC($tmpStr$, 1) # remove first character
goto #loop
Best Regards - Misi, RRR AB, http://www.rrr.se
Products from RRR Scandinavia:
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.
> I have a free form character field and need to extract digits from that
> field - may be in a filter? Am on v7.1, oracle.
>
> Any one has some function they used (like in sql or may be combination of
> strstr??) Looks painful to me.
>
> Help please
>
> Atul
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
>
> --
> This message was scanned by ESVA and is believed to be clean.
>
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
