Single Quote instead of Emtpy Field in CSV
Hey there. Anytime I have an empty field in my CSV, example:
"Bob","Cindy","","Greg"
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?
"Bob","Cindy","","Greg"
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?
Dan
July 11,