Brilliant! Thanks a million! I knew there had to be a way to setup a formula, but wasn't sure where to begin on this one. I had originally hoped Calc would let me search and replace on empty cells. Oh well. Thanks again.
Cheers, Don On 5/2/07, Anthony Chilco <[EMAIL PROTECTED]> wrote:
Hi Don, The cheap and dirty way would be to enter this into cell a1 on another sheet: =IF(Sheet1.A1<>"";Sheet1.A1;"/N") This assumes that the sheet with your data is named 'Sheet1'. Substitute the sheet name if it's not. Fill across all fifty-two columns and then down all 990 rows. Select all, copy, then paste special and check all the options except for formulas. Save the second sheet as a tab file. tc Don Parris wrote: > 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 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
-- D.C. Parris Minister, Editor, Free Software Advocate http://www.linkedin.com/in/dcparris
