Greetings, I have a large-ish Calc sheet (using 2.2.0) with empty cells interspersed throughout 52 columns and 990 rows. I will save the sheet as a tab-separated values text file, and run it through PostgreSQL's COPY command. I would like to insert a "\N" (database NULL) into the empty cells, if possible. Is there a quick-and-easy way to do this? If the cells occupied a single row or column, the answer would be pretty obvious. If there is some documentation explaining how this can be done, just point me to that.
It may be easier to tell PostgreSQL how to interpret the blank fields, and that's fine, too. Thanks, Don -- D.C. Parris Minister, Editor, Free Software Advocate http://www.linkedin.com/in/dcparris
