1) Execute it in a bash script and grep -v "0\.00" 2) Or SORT it with the total displayed in the first column and pipe the output to sort -rn
3) Or SORT it and [ipe the output to awk Etc etc. Don't limit yourselves to the MV only way of doing things as that was the whole point of jBASE. Jim From: [email protected] [mailto:[email protected]] On Behalf Of Daniel Klein Sent: Sunday, September 26, 2010 6:12 AM To: [email protected] Subject: Re: jdbc There's no iphone app that will do that? ;-) Seriously, you would spool the report to a file and then post-process the file. Dan On Sun, Sep 26, 2010 at 7:00 AM, Simon Verona <[email protected]> wrote: Hi all This may or may not be a stupid question. I have a transaction file, with many thousands of entries in, which should total zero both on a daily basis (there is a date field in the file) and overall. If I have a problem, then a check is to find which dates do not come back to zero... So, I execute a jQL query like : SORT TRANSACTIONS BY DATE BREAK-ON DATE "'VL'" TOTAL 2 (D) Which produces a list like : 02/07/2010 0.00 01/07/2010 0.00 30/06/2010 0.00 29/06/2010 -585.31 28/06/2010 0.00 27/06/2010 0.00 etc etc All I want to see though is the dates that don't come to zero.... Can this be done using jQL? Thanks Simon -- Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24 To post, send email to [email protected] To unsubscribe, send email to [email protected] For more options, visit this group at http://groups.google.com/group/jBASE?hl=en -- Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24 To post, send email to [email protected] To unsubscribe, send email to [email protected] For more options, visit this group at http://groups.google.com/group/jBASE?hl=en -- Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24 To post, send email to [email protected] To unsubscribe, send email to [email protected] For more options, visit this group at http://groups.google.com/group/jBASE?hl=en
