Performing a comparison between two .csv files to extract data

D

dbutch1976

Joined
Dec 14, 2007
Messages
6
Reaction score
0
Hello,

I need to create a .CSV file by doing a comparison between two other CSV files.

Headers from file #1 (HRFILE.CSV)

givenName phoneNumber mobile EmployeeID

Headers from file #2 (ADEXPORT.CSV)

CN EmployeeID

The HRFILE.CSV file provides a list of user accounts to modify while the ADEXPORT.CSV file is the complete list of all users in the organization. I need to write a formula which will take all users in the HRFILE.CSV and match them to a corresponding user in the ADEXPORT.CSV file. The output should be in the form of a new file called IMPORT.CSV which should contain the following information:

Headers from file #3 IMPORT.CSV

CN givenName phoneNumber mobile



It seems rather straight forward but I've never used an Excel spreadsheet to perform a comparison before. Can anyone assist with this?
 
Back
Top