Hello all-
I've got about 50 csv files that I'd like to use the command line to merge together. However, each file has a different order of column headers. Most are the same, some are unique, but they all share specific headers (like First Name, Last Name, etc).
Is there a way I can automate the reorganization of the columns or combine them with something that can detect the same column headers? Moving one column at a time will take me ages.
I'd like to share the files, but they have personal info.
But imagine I have 3 files:
File 1-
FirstName, LastName, Birthdate, Email1, Email2
File 2-
Roster, RegistrationDate, FirstName, LastName, Birthdate, Email1, Email2
File 3-
FirstName, LastName, MInitial, Birthdate, Email1, Address, City, Zip, Email2, RegistrationDate
You get the idea. ANY help is greatly appreciated.
Thanks!
Bookmarks