Script merge CSV files
I have a few .CSV files that I want to merge together (sample files attached).
The 3 .CSV files have different fields (in a different order).
I only want to merge 3 common fields (email_address, state, zip) from the files into a 4th output .CSV file.
Any ideas on how to do this with either VBScript or Windows Batch?
Thanks for any help.
File1.csv
File2.csv
File3.csv
The 3 .CSV files have different fields (in a different order).
I only want to merge 3 common fields (email_address, state, zip) from the files into a 4th output .CSV file.
Any ideas on how to do this with either VBScript or Windows Batch?
Thanks for any help.
File1.csv
File2.csv
File3.csv
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thank you very much for the great explanation. I really appreciate it.
You're very welcome. I enjoyed it. Have a great weekend...
ASKER
I might have to alter the batch file a bit based on the other CSV files I need to work with. So I am trying to interpret how the batch file determines the 3 fields to output
Could you please explain that part. Thanks again