Remove quotation marks from a CSV file

Hi,

I have a csv file and I need to remove the quotation marks from it (i need then to import the data in SQL server, and all the data has " eg "1543"). Can some one pls help; i am not a C# programer... actualy I started reading C# just for this problem. Any input is more than appreciated. Thank you for all your help.

jimache

Newbie Poster

1 post since Sep 2005

Reputation Points: 10

Solved Threads: 0

6 Years Ago

If you are importing a CSV into SQL server it will remove the quotation marks for you. Use Enterprise manager in SQL Server to import the CSV file as data and you should be fine.

If you don't have enterprise manager, then use excel or ms access to import that csv file and then re-export it as a xls or some other format post "quotation" removal.

Both routes work, as I do them on a constant basis daily.

Paladine

Master Poster

Team Colleague

824 posts since Feb 2003

Reputation Points: 211

Solved Threads: 27

This article has been dead for over three months

You