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

$25,000

$100,000

$125,000

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

FromExcel:

LOAD

[Annual Salary]

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

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

FROM …my Excel;

Skip to content