I have a CSV file that contains the columns a,b,c,d and e and another file that contains column z. While reading line by line from the 1st file I want only fields c and d and at the same time I want to compare d with z from the second file.
z is a variable meaning,
for i in catfileb do ....... Now if d is the same as z then display z, but if they are different, then always display "pin". But if z is for example longest or smallest display "lon" or "sma".
a b c d e 1 2 2 3 3 3 4 6 5 9 4 5 0 9 9
z 3 1 8
So c, d, and z are variables, so I was thinking of two loops. While reading line by line file a, get c and d, then compare with z.