Using the PurgeChar Function

Using the PurgeChar Function

The Issue at Hand:
Excel data mixes text and numbers. Excel columns are defined as “Text”. How can one work around the data in Excel in a way that allows to create a numeric expression?

Below is an example of “text” Excel data (data into the cells).

Annual Salary




There may ways to solve this. Below are two approaches:



[Annual Salary]

,PurgeChar( [Annual Salary],’$,’) AS Salary1

,Mid([Annual Salary],2) AS Salary2

FROM …my Excel;

Skip to content