The “Hey, Scripting Guys!” blog has been retired. There are many useful posts in this blog, so we keep the blog here for historical reference. However, some information might be very outdated and many of the links might not work anymore.

New PowerShell content is being posted to the PowerShell Community blog where members of the community can create posts by submitting content in the GitHub repository.

Showing results for CSV and other delimited files - Scripting Blog [archived]

Apr 6, 2005

How Can I Convert a Comma-Separated Values File to a Tab-Separated Values File?

ScriptingGuy1

Hey, Scripting Guy! How can I convert a comma-separated values file to a tab-separated values file?-- RV Hey, RV. Depending on the nature of your comma-separated values (CSV) file this is either very easy or a little bit tricky. Let’s follow the Scripting Guys Philosophy of Life and look at the easy one first. Note. Of course, in our real P...

Oct 28, 2004

How Can I Create a CSV File?

ScriptingGuy1

Hey, Scripting Guy! How can I create a CSV file?-- LF Hey, LF. For those of you who aren’t up on your acronyms, CSV is short for comma-separated-values file, a text file in which individual elements are separated by commas. For example, say you have a CSV file consisting of user first names, last names, and job titles; that file might look somet...