searching multiple csv's

[msp9000]

Greetings,

I am trying to do the following and I seem to be having issue indexing the data file: (Looks like it's indexing, but fails at the end)

1. Read from a logfile, pulling the appropriate lines needed
2. Read from 2 other data files while reading from the main logfile.
3. Compare relevent data, and generate pass/fail string
4. Generate a consolidated output file

 Here's an example of how I would like my output:

20150121 173302, Pass#, 1, Facets:, 45387, Start facet:, 18, First Facet, 18, ST Count, 45387 ,First Facet Pass, ST Count Pass

Can someone show me the error of my ways? Currently, I'm only getting the first line of the other 2 data files, when I connect the indexing I get 0's.

Also, I'm stuck on a good way to handle potentially missing data?

Thanks!

Here's examples of the input file, some attached:

20150501 200541,Pass# ,1,OPF Count,45387,ST Count,45387
20150501 200542,Pass# ,2,OPF Count,45387,ST Count,45387
20150501 200543,Pass# ,3,OPF Count,45355,ST Count,45355
20150501 200544,Pass# ,4,OPF Count,491,ST Count,491
20150501 200545,Pass# ,5,OPF Count,46571,ST Count,46571
20150501 200546,Pass# ,6,OPF Count,46571,ST Count,46571
20150501 200547,Pass# ,7,OPF Count,49739,ST Count,49739
20150501 200548,Pass# ,8,OPF Count,49739,ST Count,49739
20150501 200549,Pass# ,9,OPF Count,49739,ST Count,49739
20150501 200550,Pass# ,10,OPF Count,49739,ST Count,49739
20150501 200551,Pass# ,11,OPF Count,49739,ST Count,49739
20150501 200552,Pass# ,12,OPF Count,49739,ST Count,49739
20150501 200553,Pass# ,13,OPF Count,49739,ST Count,49739
20150501 200554,Pass# ,14,OPF Count,49739,ST Count,49739
20150501 200555,Pass# ,15,OPF Count,53868,ST Count,53868

[mikeporter]

I can't look at your code on my phone, so let me just say that the number 1 "error of your ways" is that you are trying to do this with text files. This is an application that simply cries out for a database.

Mike...

[RavensFan]

The way you have it set up, you are looking at the same line number in every file on each iteration.  Is that what you want?  Only if your data is aligned the same between through all 3 files would this work.