Single Quote instead of Emtpy Field in CSV
The grid will display as such:
Bob | Cindy | ' | Greg
For some reason, it puts a single quote (') in the NULL fields. I've tried this with tab deliminated too, same results. I can't seem to get rid of the pesky little ' no matter what I do. I'm using IE. You can recreate the problem by deleting a field in the sample CSV file.
Is there anyway to fix this problem?