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
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.)
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!