On Mon, Mar 21, 2011 at 11:29, Rich Shepard <[email protected]> wrote: > Perhaps I'm not using the proper search string in the OO.o help and on > Google, but I cannot find how to replace a blank spreadsheet cell with "NA" > as the contents. Does anyone here know?
From OO.o's wiki page on Find & Replace for Calc: "Searching for the regular expression ^$ will not find empty cells. This is intentional—the rationale being to avoid performance issues when selecting a huge number of cells. Note that empty cells will not be found even if you are only searching a selection." (http://wiki.services.openoffice.org/wiki/Documentation/OOo3_User_Guides/Calc_Guide/Find_and_replace) It doesn't look like you can search for a blank cell in calc. On Mon, Mar 21, 2011 at 11:56, Rich Shepard <[email protected]> wrote: >  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. There's a really cool open source project for managing just this kind of problem (cleaning up data) called "Google Refine" (they bought Freebase and released refine as open source). The introduction videos act as great tutorial. http://code.google.com/p/google-refine/ Although you have to download and run it locally, it's pretty easy, usually just something like: $> tar -zxvf google-refine-2.0-r1836.tar.gz $> cd google-refine-2.0 $> ./refine Cheers, Daniel Hedlund [email protected] _______________________________________________ PLUG mailing list [email protected] http://lists.pdxlinux.org/mailman/listinfo/plug
