From: Robert Klemme <shortcutter@...>
Date: 2008-08-22T05:26:41+09:00
Subject: Re: want to compare data in two files.

On 21.08.2008 22:02, viupljindal@gmail.com wrote:
> I have two CSV files and i want to find the duplicates records.
> 
> For ex.
> 
>  Sheet1                                  Sheet2
>  Vipul                                     Anthony
>   John                                    Wayne
>   Mac                                     Bill
>   smith                                    randy
>   Nick                                      thalia
>                                               Trishi
>                                               ricky
>                                               sachin
>                                               Nick
> 
> 
> So i want to check the appearance of each record of Sheet1 in the
> sheet2, like i want to check if vipul exist in sheet2 or not.
> 
> Is there any automated tool for it or do i have to do it manually.

Not sure what you want (or rather, why you are asking here if you just 
want a quick solution) but there is of course

 >> diff -u <(sort Sheet1) <(sort Sheet2)

Note, you need a decent shell and OS for this (bash on Linux will do). 
Otherwise you need temporary files.

Cheers

	robert