<div>
Ok I see what you did. So if i wanted to keep it as a true .csv file would i need to do the split something like this? .Split(&quot;,&quot;) <br />
<br />
Which I assume would keep all the data in one column under the header?<br />
<br />
Column1,<br />
Item1,<br />
Item2,<br />
Item3,
</div>


Ok I see what you did. So if i wanted to keep it as a true .csv file would i need to do the split something like this? .Split(",")

Which I assume would keep all the data in one column under the header?

Column1,
Item1,
Item2,
Item3,

<div>
Sorry, can't follow you.<br />
Based on your example, the text file you have seems to be a csv already - a header line and some rows with items. It's a csv with only one column, but a csv nevertheless.
</div>


Sorry, can't follow you.
Based on your example, the text file you have seems to be a csv already - a header line and some rows with items. It's a csv with only one column, but a csv nevertheless.

<div>
actually its not including commas at all i see
</div>


actually its not including commas at all i see

<div>
With only one column, there are no fields to separate, hence no field separator. If there were a comma at the end, it would indicate a second column without data in it, and a missing column header.<br />
Just run an &quot;Import-Csv&quot; on the file content you posted - you'll get an array of objects with one property, &quot;Column&quot;.
</div>


With only one column, there are no fields to separate, hence no field separator. If there were a comma at the end, it would indicate a second column without data in it, and a missing column header.
Just run an "Import-Csv" on the file content you posted - you'll get an array of objects with one property, "Column".

<div>
Your code worked as expected. Thank you for the help!
</div>


Your code worked as expected. Thank you for the help!

<div>
<div class="content wysiwyg-content">
I am trying take a text file that looks like this:<br />
<br />
Column<br />
Item 1<br />
Item 2<br />
Item 3<br />
<br />
and make it look like this in .CSV format<br />
<br />
Column,<br />
Item1,Item2,Item3<br />
<br />
When I try CovertTo-CSV I get output such as:<br />
<br />
#Type System.string <br />
&quot;Length&quot;<br />
&quot;4&quot;<br />
&quot;8&quot;<br />
&quot;7&quot;<br />
etc.<br />
<br />
Can someone please advise?<br />
<br />
Thanks!
</div>
</div>


I am trying take a text file that looks like this:

Column
Item 1
Item 2
Item 3

and make it look like this in .CSV format

Column,
Item1,Item2,Item3

When I try CovertTo-CSV I get output such as:

#Type System.string 
"Length"
"4"
"8"
"7"
etc.

Can someone please advise?

Thanks!

Add commas to text file and save as .csv using Powershell

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.