Topic
1 reply Latest Post - ‏2013-10-10T07:01:18Z by liuhoting
MMarcus
MMarcus
1 Post
ACCEPTED ANSWER

Pinned topic Counts and Evaluation by Substring

‏2013-10-09T03:46:00Z |

Hello--

Requesting assistance in developing the report code for the following situation:

I have a log file (see attached file) with three columns on each line:  set#, True/False, filename

Sample:
"set01.0110.a","False","C:\temp\file.txt"
"set01.0110.b","True","C:\temp\file.txt"

The set# is comprised of "setdd.nnnn.a"  where dd is a two-digit number, nnnn is a four-digit number, and a is a letter.  (eg set01.0010, set01.0090, set01.0200)

I need to:

1. For each collection of rows where setdd.nnnn is the same (.a varies), evaluate all the TRUE/FALSE values so that setdd.nnnn returns TRUE if ALL the values are TRUE and FALSE if ANY of the values are FALSE.

2. Count the total number of sets, the number of sets which evaluate to TRUE, and the number that evaluate to FALSE.

3. Display the filenames for each row which contains FALSE, where the set evaluates to FALSE. (This could be a separate report.)

Example:

Sets    TrueSets   FalseSets

20         16  (set01.0010, set.01.0030,..,set01.0200)            4 (set01.0090, set01.0110, set01.0150, set01.0160)

Many thanks for your time, insight, and assistance!

MMarcus

Attachments

Updated on 2013-10-09T03:51:25Z at 2013-10-09T03:51:25Z by MMarcus
  • liuhoting
    liuhoting
    19 Posts
    ACCEPTED ANSWER

    Re: Counts and Evaluation by Substring

    ‏2013-10-10T07:01:18Z  in response to MMarcus

    So I tried fiddling around for a little bit. I don't think I'm quite where you want to be but maybe this can get you started...

    The point I got to was basically to count all of the entries that had "false" or "true" in your set of data, and then to get the set01.0010 stuff. I figure after that you can just do some kind of sort or export it into some other program. I was basically playing around until I realized I only took into account condition 2 and condition 3 but not condition 1 (oops).

    Here are some relevance queries:

    Q: lines of file "C:\truefalsefile.txt"
    A: "set01.0110.a","False","C:\temp\file.txt"
    A: "set01.0110.b","True","C:\temp\file.txt"
    A: "set01.0110.ac","False","C:\temp\file.txt"
    A: "set01.0110.b","True","C:\temp\file.txt"
    A: "set01.0110.ad","False","C:\temp\file.txt"
    A: "set01.0110.be","True","C:\temp\file.txt"
    A: "set01.0110.af","False","C:\temp\file.txt"
    A: "set01.0110.bg","True","C:\temp\file.txt"
    A: "set01.0110.ah","False","C:\temp\file.txt"
    A: "set01.0110.ba","True","C:\temp\file.txt"
    A: "set01.0110.ac","False","C:\temp\file.txt"
    A: "set01.0110.beea","True","C:\temp\file.txt"
    T: 0.605 ms
    I: plural file line

    Q: number of lines of file "C:\truefalsefile.txt"
    A: 12
    T: 0.579 ms
    I: singular integer

    Q: lines whose (it as string contains "False") of file "C:\truefalsefile.txt"
    A: "set01.0110.a","False","C:\temp\file.txt"
    A: "set01.0110.ac","False","C:\temp\file.txt"
    A: "set01.0110.ad","False","C:\temp\file.txt"
    A: "set01.0110.af","False","C:\temp\file.txt"
    A: "set01.0110.ah","False","C:\temp\file.txt"
    A: "set01.0110.ac","False","C:\temp\file.txt"
    T: 0.633 ms
    I: plural file line

    Q: preceding texts of firsts "," of (lines whose (it as string contains "False") of file "C:\truefalsefile.txt" as string)
    A: "set01.0110.a"
    A: "set01.0110.ac"
    A: "set01.0110.ad"
    A: "set01.0110.af"
    A: "set01.0110.ah"
    A: "set01.0110.ac"
    T: 0.637 ms
    I: plural substring