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 <[email protected]> > To: [email protected] > 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" <[email protected]> wrote: On US standard keyboards | is on the row above the Enter key on the end of the row. -- Jay Lozier [email protected] -- Unsubscribe instructions: E-mail to [email protected] 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
