in reply to compare records in two csv files

boddeti,
With having only read the title and the first line of your question I would suggest taking a look at CSV table diff utility for ideas. If it is not applicable to your problem I apologize.

Cheers - L~R