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

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:
-- 
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