The UNIX and Linux Forums  

Go Back   The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
Reload this Page Need help on comparison of two csv files
.
google unix.com

Forums Register Forum RulesLinksAlbums FAQ Members List Calendar Search Today's Posts Mark Forums Read



Thread: Need help on comparison of two csv files
View Single Post in the UNIX and Linux Forums - Click on the Thread or Permalink to View Entire Thread -->
  #1 (permalink)  
Old 08-06-2008
sourav1982 sourav1982 is offline
Registered User
  
 

Join Date: Aug 2008
Posts: 2
Post Need help on comparison of two csv files
Dear All,

I want to compare two csv files using shell programming -

File 1 contents

44,,NONE,0,,2/2/1901
66,,NONE,0,,2/3/1901

File 2 Contents

1022,3708268,AUFX,0,100919,3/1/2006
66,,NONE,0,,2/3/1901

After comparing each column/field I want to print the occurances of difference for each field/column i.e suppose if 44 and 1022 doesn't match then it will be 1, suppose if it matches then it will be 0. My ultimate goal is to count the total number of differences for each field. Any help will be highly appreciated.