An issue people often struggle with in data matching is the inclusion of random quotes within columns of data – for example,
Company_Name = O”hara systems corp
When you export data into a quoted CSV format, the rogue quotes (“) cause problems with systems being able to properly identify the columns within the list.
An easy solution for this is to use the REPLACE function available in most database systems during the output, i.e.
REPLACE(Company_Name,’”‘,”)
An example of this in SQL Server would be:
SELECT
REPLACE(FIELD_NAME,’”‘,”) as FIELD_NAME
,REPLACE(Address1,’”‘,”) as Address1
,REPLACE(Address2,’”‘,”) as Address2
,REPLACE(City,’”‘,”) as City
,REPLACE(County,’”‘,”) as County
,REPLACE(ZIP,’”‘,”) as ZIP
,REPLACE(Tel,’”‘,”) as Tel
FROM
MY_TABLE_NAME
Using the REPLACE function will eliminate these rogue quotes from your lists and ensure that other tools and systems can properly identify and parse the columns within your CSV files.
For more information on using the REPLACE function in your database systems see:
