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?