Rich Shepard wrote: > On Mon, 21 Mar 2011, Fred James wrote: > > >> Obviously there is the "type it in answer" ... but maybe that's not what >> your >> are looking for? >> > > Fred, > > Not when there are dozens of such empty cells on the page. > > >> Are you looking for something in the "Find and Replace" arena? Or are you >> asking a logic question? Or something else entirely? >> > > I have several dozens of client spreadsheets (all Excel, of course) with > about 30 years' worth of compliance monitoring data. Different operators > over the years and absolutely no standards for data organization or page > structure. Or anything else. > > To import these data into postgres for statistical analyses with R I need > to code missing values (blank cells) as NA (not available). I could do this > after exporting the page as a .csv file, but wondered if there was a way to > have the search field in "Find & Replace" blank the way we can have the > replace field blank to remove cruft. > > Thanks, > > Rich > Rich Shepard Oh, that is what I feared ... no way in OOo (or Excel, I think) to do that ... think of all the blank cells outside of your scope of interest. Best done with SED or EX in the *.CSV file, I should think. Hope that helps Regards Fred James
_______________________________________________ PLUG mailing list [email protected] http://lists.pdxlinux.org/mailman/listinfo/plug
