Help Needed with a script

Posted May 4, 201410 yr

Hi I have 2 files and i want to perform difference between file2 and file1 (the new output shud pull both columns)

File2 has all Data and File1 has few data

All i want is 2 things.

1. Generate the difference between file2 and file1, the new output will have all the data that is not from file 1 ( should print both columns)

2. Generate "sing quotes" to column1 of file1 start and end either using awk/sed

i Tried using while loop but no luck with the output.

Both files has 2 columns

your help is appreciated.

attached files... also posted here

file2

NAME State

------ ------

Austin AZ

Bretea PA

Casey MD

David FL

Edison NJ

Jermey NC

John CA

Juliet CA

Justin NC

Maddy VA

Michael FL

Robin NY

Scott CA

file1