I get csv files from clients which I need to read, test data then import. All this is done, however, I do have one sticking point which I just dont seem to be able to get around.
Do While Not ImportFile.EndOfStream
ImportLine = ImportFile.ReadLine
LineArray = Split(ImportLine, ",")
If LineArray.GetUpperBound(0) > 0 Then
Begin()
' My code here
End
End If
Loop
ImportFile.Close()
Problem is when there is a comma in the middle of a field. I have been looking at the csv prasers on the net but dont seem to be able to find anything that will return back to LineArray.
This line works fine :
"11-22-33","12345678","360","REF0001","1.00","17"
This line causes pro ...
Go to the complete details ...