Depending on how the data is in the string (and since you are on Oracle) you
can use the Regexp_REPLACE oracle function
In a Set Fields from SQL action set a field equal to $1$ from:
SELECT Regexp_REPLACE('$source field$ ',
'([[:cntrl:][:punct:][:space:][:alpha:]])','') from DUAL
This will remove all control, punctuation, white space, and alpha characters
from the string. (Yes there is a space after the source field so in case the
source field is null then the function will not error but will return null)
For Oracle REGEXP functions you can reference:
http://psoug.org/reference/regexp.html
Fred
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[email protected]] On Behalf Of Atul Vohra
Sent: Wednesday, April 14, 2010 8:42 AM
To: [email protected]
Subject: Extracting digits from a character field
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
