Indeed Tom, that simple:) Thank you! As for other request, I want all data because unconfirmed is just one of the many stats I pay attention to. Easiest to pull everything and then make custom accumulated files from the entire data set. Best, Joel On Fri, Apr 12, 2013 at 10:22 AM, Tom Davies <tomdavies04@yahoo.co.uk>wrote:
Hi :) Perhaps a command-line filename.csv | grep Unconfirmed > new-filename.csv or something like that? or some similar function in Calc, one of the something-if commands? Regards from Tom :)________________________________ From: Alexander Thurgood <alex.thurgood@gmail.com> To: users@global.libreoffice.org Sent: Friday, 12 April 2013, 17:43 Subject: [libreoffice-users] Re: Adding values to CSV File via Terminal Le 12/04/13 16:12, Joel Madero a écrit : Hi Joel,Might start a new thread about this one but, have a bit of a trickier one now. In the file there are lines that have UNCONFIRMED on a specific line (this is again, a pull list from FDO). What I would like to do is merge all the files but only keep the rows that have "UNCONFIRMED" (or anything else, that's just one stat that we're really interested in). So, the list is much too long to merge everything (3 months worth at this point), but I think if I could just get the UNCONFIRMED lines and merge into a new file completely (unconfirmed bugs January - March.csv), I could use the data to do some quick number crunching. The idea is we want to make sure that the QA team is moving forward always, it's good to set goals but we need to be able to track the goals and what not.Wouldn't tailoring your query in bugzilla help with this one, i.e. limiting the query to only those with unconfirmed status, or am I missing something ? Alex -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.org Problems?http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot bedeleted-- For unsubscribe instructions e-mail to: users+help@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
-- *Joel Madero* LibreOffice QA Volunteer jmadero.dev@gmail.com -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted