Atul: Being an old-fashioned kind of guy, I'd loop through the source field one character at a time, and if a character is a digit, then append it to a temporary field. When you reach the end of the source field, your temporary field will contain all the digits. Maybe best built as a Filter Guide?
Just a Thought, --Phil -------------------- Phil Murnane, Sr Consultant Windward IT Solutions, Governance and Fulfillment Practice Email: pmurn...@windwardits.com Mobile: 703-896-6435 Web: www.WindwardITS.com -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Jim Fox Sent: Wednesday, April 14, 2010 11:12 To: arslist@ARSLIST.ORG Subject: Re: Extracting digits from a character field On MS-SQL, trying to replace one character with Null is not a good idea. Fluxman ------Original Message------ From: Joe D'Souza Sender: Action Request System discussion list(ARSList) To: arslist@ARSLIST.ORG ReplyTo: arslist@ARSLIST.ORG Sent: Apr 14, 2010 11:07 Subject: Re: Extracting digits from a character field If you are in an Oracle database, use the function TRANSLATE to replace all Alpha characters with either NULL or space or whatever else you wish to.. This will leave the string with only special characters and numerical characters.. I am not sure if TRANSLATE works on MS-SQL but you could give it a shot if MS-SQL is your underlying database. Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Atul Vohra Sent: Wednesday, April 14, 2010 9: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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" Sent from my Verizon Wireless BlackBerry _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
