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 <[email protected]>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 <[email protected]> > >To: [email protected] > >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: [email protected] > >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 > > > > > > > > > -- > For unsubscribe instructions e-mail to: [email protected] > 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 [email protected] -- For unsubscribe instructions e-mail to: [email protected] 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
