I have a csv file in below format
1311,0008,a131,a131,7039
1311,0008,a131,a132,7039
1711,2046,a626565,a626566,7099
1711,2048,a626565,a626565,7035
What I want is to compare column 3 and 4 only and if they do not match, print that line in a new file and if they match print that line in another file
Expected File1 output (where col 3 & 4 do not match) :
1311,0008,a131,a132,7039
1711,2046,a626565,a626566,7099
Expected output in File2 (where col 3 & 4 match) :
1311,0008,a131,a131,7039
1711,2048,a626565,a626565,7035
So far I have tried the comparison with multiple files only.