[PLUG] OO.o Calc Question

Fred James fredjame at fredjame.cnc.net
Mon Mar 21 19:09:24 UTC 2011


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




More information about the PLUG mailing list