http://qs1969.pair.com?node_id=1044659

mmittiga17 has asked for the wisdom of the Perl Monks concerning the following question:

Hi Monks, Having trouble trying to figure out best way to validate a csv file is good based on two csv fields.

field1 field2 3-2000/7.48 1 3-2000/7.48 2 3-2000/7.48 2 3-2000/7.48 2 3-2000/7.48 2 3-2000/7.48 2 3-2000/7.48 2 3-2000/7.48 3 4-0000/8.40 2 4-0000/8.40 2 4-0000/8.40 2 4-0000/8.40 2 4-0000/8.40 2 4-0000/8.40 2 4-0000/8.40 3

to be able to say file is good, each unique ID "field1" will need have a field2 at some point that is 1 and 3. this example above 3-2000 has a record of both a 1 and 3 in field2 however 4-0000 does not have a record with 1 in field2 Ideas suggestions? Thanks in advance.