VB.Net Data Import
Posted on 2012-09-06
i am trying to write some code which reads line by line of a text file (CSV) and trys to import them. Here is my 2 issues which i am trying to deal with.
Some fields have a ' in it like Names Walther's etc how do you gracefully handle ths ?
Also some fields have a comma in the field but then the field is enclosed by " how can i check for that ? If i just set my Spliter to , it will see the , in the field as another seperator.