How to copy/duplicate a column in a csv file?

Hello,

How can I copy/paste/duplicate a column in a csv file so the column appears twice in the csv file?  So.. columns are..

title, employeeID, employeeID, telephone  

The employee ID is deuplicated to the right.   I then would like to change the header of the 2nd employee ID header.  

The reason for this is we use the employeeID for binding and then use it again to display under the company field.  

Thanks for any helps!
SA-mattmanAsked:
Who is Participating?
 
QlemoConnect With a Mentor Batchelor, Developer and EE Topic AdvisorCommented:
import-csv "c:\temp\source.csv" | 
  select-object title, employeeID, @{n = "employeeIDdup"; e = employeeID}, telephone | 
  export-csv "c:\temp\dest.csv" -NoTypeInfo

Open in new window

should do that, with an column named employeeIDdup inserted after the employeeID column.
0
 
SA-mattmanAuthor Commented:
Awesome.  That did it.  Had to fix one small thing.  Appears the e = employee needs quotes around it as well to work.   After that, worked like a chart!  

Thanks a million!
0
 
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
Sorry for that. Yes, e= (which is short for expression=) needs an expression, so usually we provide a script block in curly braces. But using double quotes is ok, too. The "correct" notation is:
import-csv "c:\temp\source.csv" | 
  select-object title, employeeID, @{n = "employeeIDdup"; e = {$_.employeeID}}, telephone | 
  export-csv "c:\temp\dest.csv" -NoTypeInfo

Open in new window

but that is less "elegant" as just using e = "employeeID" ;-)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.