Date: prev next · Thread: first prev next last
2011 Archives by date, by thread · List index


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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.