<div>
Awesome. &nbsp;That did it. &nbsp;Had to fix one small thing. &nbsp;Appears the e = employee needs quotes around it as well to work. &nbsp; After that, worked like a chart! &nbsp;<br />
<br />
Thanks a million!
</div>


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!

<div>
Sorry for that. Yes, <b>e=</b> (which is short for <b>expression=</b>) needs an expression, so usually we provide a script block in curly braces. But using double quotes is ok, too. The &quot;correct&quot; notation is:<br />

<pre><code id="code-20-37394525-1">import-csv &quot;c:\temp\source.csv&quot; | 
  select-object title, employeeID, @{n = &quot;employeeIDdup&quot;; e = {$_.employeeID}}, telephone | 
  export-csv &quot;c:\temp\dest.csv&quot; -NoTypeInfo</code></pre>
but that is less &quot;elegant&quot; as just using <b>e = &quot;employeeID&quot;</b> ;-)
</div>


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

but that is less "elegant" as just using e = "employeeID" ;-)

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
How can I copy/paste/duplicate a column in a csv file so the column appears twice in the csv file? &nbsp;So.. columns are..<br />
<br />
title, employeeID, employeeID, telephone &nbsp;<br />
<br />
The employee ID is deuplicated to the right. &nbsp; I then would like to change the header of the 2nd employee ID header. &nbsp; <br />
<br />
The reason for this is we use the employeeID for binding and then use it again to display under the company field. &nbsp;<br />
<br />
Thanks for any helps!
</div>
</div>


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!

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

Windows PowerShell is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language built on the .NET Framework. PowerShell provides full access to the Component Object Model (COM) and Windows Management Instrumentation (WMI), enabling administrators to perform administrative tasks on both local and remote Windows systems as well as WS-Management and Common Information Model (CIM) enabling management of remote Linux systems and network devices.