I'm trying to import a CSV file into SQL. I have the SQL code working, then I found out that the file has commas embedded in the data:
3000 Server - N4000,A6914CR,"3000 Server - N4000 - 1-way, 500MHz",A3639-67021,Electronic Parts,Cable Kit
Notice that the third data item is enclosed in quotes and has a comma in it, so when the SQL batch import code runs, it brings the data in wrong.
The question is, how do I clean up this data. There is going to be many files, with 5000+ rows each.
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people