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:arsl...@arslist.org] On Behalf Of Atul Vohra Sent: Wednesday, April 14, 2010 8:42 AM To: arslist@ARSLIST.ORG 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