[hacksaw74]

I have created an application that parses some text files and pulls out and sorts the information into a table

Here is a sample

NODE	DSP Name	BUS	IDENT	STATION	  REF1	                REF2
nnn1_1	S|xxxx|A1	1	1	1	  S|yyyyyyyyyy|A1   	S|zzzzzzz|A1
mmm1_1	R|xxxx|A1       1	1	1	  R|yyyyyyyyyy|A1	R|zzzzzzz|A1
xxx1_2	R|xxxx|A1	1	1	1	  R|yyyyyyyyyy|A1	R|zzzzzzz|A1
yyy1_1	R|xxxx|A1       1	1	1	  R|yyyyyyyyyy|A1	R|zzzzzzz|A1

I need to check 3 things

1) That if in the DSP Name there is a S| that it has at least one corresponding R|
2) That the corresponding R| have identical BUS,IDENT,STATION
3) That REF1 and REF2 match names

I can sort of brute force my way through this pulling in the table one line at a time and building a list of all the (S|) and then once have that list search for the corresponding (R|)...
I already have the these in a datatable at one point, as well as a CSV file

Is there a simpler way to do this? Like LINQ?

[Skydiver]

What's suppose to happen if one of the conditions is not met? Is it a matter of pass/fail for the entire data collection, or only a pass/fail for a given "S|" ?

[hacksaw74]

For the first check it would only flag the individual "S|" row that had no corresponding "R|"

for the check 2 and 3 I would only highlight the cell mismatch