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