Hey, Scripting Guy! I have a comma-separated values file that I need to import into Excel. However, before I do that I need to do some arithmetic and then add an additional field to the CSV file. On top of that,
Hey, Scripting Guy! How can I delete the duplicate entries in a tab-delimited file?— ST
Hey, ST. Before we start, is anyone out there familiar with the book Not Quite What I Was Planning: Six-Word Memoirs by Writers Famous and Obscure?
Hey, Scripting Guy! have a comma-separated values file that includes several different fields. I’d like to be able to read this file from Windows PowerShell and then sort the information on one (or maybe more) of these fields. However, I can’t seem to get this to work.
Hey, Scripting Guy! I have a text file which consists of individual fields separated by commas. I need to look at the second field in each line and, if it includes the word Everyone, I then need to take the sixth field in the line and write that value to a second text file.
Hey, Scripting Guy! How can I copy selected columns from a CSV file to an Excel file?— MdP
Hey, MdP. One thing that people always worry about (and rightly so) is that one of these days the Scripting Guys will do something that tears a hole in the space-time continuum.
Hey, Scripting Guy! How can I parse a tab-delimited file, and then save the resulting information as a comma-separated values file?— DM
Hey, DM. You know, yesterday morning the Scripting Guy who writes this column had to scrape the ice off his windshield;
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.
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,