CSV is one implementation of a delimited text file, which uses a comma to separate values (where many implementations of CSV import/export tools allow an alternate separator to be used), they can read through Notepad or Spread Sheets or Word Applications.

This project will be helpful for comparing two CSV files which may have unordered column of data.

Consider we have bulk of records of employees in two files, one is gathered from HR department of their current company which may have field names as EmpName, EmpAdd, EmpPhone, EmpID and etc., another one is gathered from previous company where they worked that file also may have same EmpName, EmpAdd, EmpPhone, EmpID. If anyone want to check whether the employee has given correct data, they can use this application.

1. Lets look the First screen of CSV-Comparison project. (See screen1: FirstScreen). Load the file1 “100-comma1-Non-case sensitive” for Load File1and load second file “100-comma2-Non-case sensitive” for Load File2 by using buttons Browse File 1 and 2 respectively.

1.1The special thing of the project is we can compare two text file with out column heading. Our application will assign field1, feild2, as default header for columns which do not have header. We have to just check the check-box “Is Heading available?”

1.2 While the file loading user can view a cancel button to cancel the loading file so the user can cancel the file loading.

Delimiter text box in default comes with comma. We can change with space or symbols before loading.

1.4 If you want to compare those two files with Case-Sensitive you check accordingly.

The following screen is taken while the second file is loading into grid (see screen2: second file is loading).

After the file loaded third box shows common fields between file1 and file2 as follows (see screen3: shows common fields). Now we have check boxes for common fields which allows us to select the column, on selected column the Comparison process will work.

Now we select the age, first name, phone for comparison. Then screen appears as

After selection here we pressed “show values exist in both files” button.

After the comparison the common fields which are available in two files means we can view a separate window for common records as follows

Now we can select them and copy and paste into spreadsheet or some where else we can store into separate file

Above screen shows common fields which are exist between two files. We can also see common fields which are not available in second file. That is available only in first file only.

Comparison will take several minutes according to the number of records available.