Strip Non Numeric Characters

Non numeric characters can be removed quickly from a projection with the REGEXP_REPLACE function.

Phone numbers are commonly entered in multiple formats:

• [phone]

• [phone]

• 123-456-7890

• 123 456-7890

This projection removes non numeric characters to output the results in the same format (1234567890) with the REGEXP_REPLACE function.

<quer:projection alias="HomePhone"> 
            <quer:customFunction name="REGEXP_REPLACE"> 
                        <quer:field path="Candidate,HomePhone"/> 
                        <quer:string>\D</quer:string> 
                        <quer:string/> 
            </quer:customFunction> 
</quer:projection>

Regular expressions are a powerful tool that can also be used for other data transformations.