Newbie question...reading delimeted files then printing certain fields and doing calculations.

From: Markis Landis Gardner (math_nospam_math_at_bellsouth.net)
Date: 12/24/03 

Date: Tue, 23 Dec 2003 23:29:05 -0500

Reading files - pipe delimited or comma delimeted...
Searching for a element in one field and then showing certain fields where
element is in line.

eg...
HEHE|HI|ME|2.5
JOKE|HELLO|YOU|3.4
DONT|HI|YOU|3.4

I want all rows with YOU in second column and I want to print out 2nd and
4th columns.

SO, my answer would be
HI 2.5
HI 3.4
...

Next question...
same list only a datestamp on the end...
HEHE|HI|ME|2.5|20031223091234
JOKE|HELLO|YOU|3.4|20031223091245
DONT|HI|YOU|3.4|20031223091247
....

1) I want all rows with YOU in second column and I want to print out 2nd and
4th columns in the 09:00:00 - 09:59:59 time frame.
2) I want an average of response time.
3) I want an average of response time broken down by hour.

Can someone help with all of this?

Please email to my home email (feel free to copy here).

math_no_spam_math@bellsouth.net
take out the _no_spam_

Thanks,

Markis

Relevant Pages

  • Re: Newbie question...reading delimeted files then printing certain fields and doing calculations.
    ... > Searching for a element in one field and then showing certain fields where ... > I want all rows with YOU in second column and I want to print out 2nd and ... > 3) I want an average of response time broken down by hour. ... > Please email to my home email. ...
    (comp.lang.java)
  • Newbie question - reading delimited files and printing...
    ... Searching for a element in one field and then showing certain fields where ... I want all rows with YOU in second column and I want to print out 2nd and ... Please email to my home email. ...
    (comp.lang.java.programmer)
  • Re: Newbie question - reading delimited files and printing...
    ... Markis ... > I want all rows with YOU in second column and I want to print out 2nd and ... > same list only a datestamp on the end... ... > Please email to my home email. ...
    (comp.lang.java.programmer)
  • RE: 2 IDs 1 Name
    ... I'll add to make the size of the second column 0 in the properties of the ... combo box if it is showing and you don't want to see the ID. ... > You would have column 2 as the bound column. ... >> FROM tblMVUP ...
    (microsoft.public.access.queries)
  • sort a subform containing 2 combo boxes
    ... My subform contains 2 combo boxes which bound by their first ... column but showing the second column. ... Is there a way that I can sort first by Combo1, ...
    (microsoft.public.access.formscoding)