:: Forum >>

Single Quote instead of Emtpy Field in CSV

Hey there. Anytime I have an empty field in my CSV, example:


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?
Monday, July 11, 2005
Yes... an empty/null field will display the single quote you mention. You can get rid of it by just putting a space between the 2 quotes " ".
Monday, August 15, 2005

This topic is archived.

Back to support forum

Forum search