Data Import from a CSV file
Posted on 2014-08-07
I have been supplied with a text file with comma separated values which require update to a database.
When read in programmatically the string has an ASCII Null between every character
eg. D A V 0 0 1 , J u l i e , D a v i e s - J o n e s ,
In notepad the file displays correctly as DAV001,Julie,Davies-Jones
The supplier of the file is downloading the file from a web site of an international company so I am unable to contact the originator.
Since Notepad is automatically stripping out the nulls is there a Windows API function I can utilise to replicate the Notepad functionality