Re: [libreoffice-users] LibreOffice Calc - Filter text

Hi

On Sat, 2011-05-14 at 06:48 +0100, Tom Davies wrote:

> Hi :)
> Which Operating System are you using; Windows, Ubuntu, another linux distro, Bsd 
> or Mac?  For the non-Windows ones in the list (ie all the unix-based ones) it 
> might be worth exploring using a command-line tool which could then be made into 
> a button on your taskbar or something.  It would be something like
>
> cat FileName.Csv | grep words-to-filter-for > NewFileName.Csv
>
> As i said, i don't know the unix command-line well enough but i'm sure someone 
> on this list could make it more accurate.  The | is near the left-shift key on 
> Uk keyboards but somewhere around the enter key on laptops and american 
> keyboards, it's not an l, on the keyboard it's usually shown with a gap in the 
> middle to show its a filtering command.  
>
>
> The Csv format is very handy precisely because it is basically a text-file with 
> commas after each cell and so it can be manipulated even without opening a 
> program such as a spreadsheet program.
> Good luck and regards from
> Tom :)
>
>
>
>
> ________________________________
> From: phantom 1969 <phantom1969@gmail.com>
> To: users@libreoffice.org
> Sent: Sat, 14 May, 2011 0:58:26
> Subject: Re: [libreoffice-users] LibreOffice Calc - Filter text
>
> Thanks for everyone's help, but I am not trying to figure out how to save a
> document as .csv, but trying to figure out how to filter a .csv document by
> a word or phrase, and extract that data from within one document and save it
> to another. Similar to using "Find & Replace" to search for a word or phrase
> within a document. I just can't figure out how to extract the found data to
> create a separate document with only the extracted data to create a separate
> document , such as another .csv document.
> On May 13, 2011 7:06 PM, "Tom Davies" <tomdavies04@yahoo.co.uk> wrote:


On US standard keyboards | is on the row above the Enter key on the end
of the row.
-- 
Jay Lozier
jslozier@gmail.com



-- 
Unsubscribe instructions: E-mail to users+help@libreoffice.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/www/users/
All messages sent to this list will be publicly archived and cannot be deleted