Shell Programming and Scripting

Hi, im extracting data from oracle DB. As the data is case sensitive, i have to extract the data which doesn't match exactly. im poor in unix scripting, can someone plz help me with a script. Here are the details.
Need to compare the second column of the each line of the file1.csv with the data in file2.csv file and create a output file only if the exact match is not found in file2.csv.
For example, BANDHI in first line of the file1.csv doesn't exactly match with the Bandhi, so it should c0onsider this line. Exact match for 'Ramonih' is found in file2.csv so it should not take this line. So totally output file should like below.

You should take a look at comm & join commands

All the best

Hi,
Try this one

Code:

fgrep -f file2.csv file1.csv

Cheers,
~senthil

Try:

Code:

awk '
  NR==FNR{
    A[$1]
    U[toupper($1)]
    next
  } 
  toupper($2) in U && ! ($2 in A) {
    $1=$1
    print
  }
' OFS=, file2 file1

Hi Senthil, Thanks for the command.

the above command is displying the matching records from file1.csv, i need the output of un-matching records. is there any command ?

Just add

Code:

-v

option to it