I have a csv file that is a source for importing data into AD. The following are the column headers:
The file has some records with a middle initial or middle name in the FirstName column:
Alan S. Alex John
Those records with the middle initial or middle name do not update in AD because they do not exist in the FirstName (gn) field in AD.
I have a command that splits the first name at the space and selects the first record . But how do I write that back to the CSV file without changing the rest of the file so I can update those records properly in AD.