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

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? Not Quite What I Was Planning is an interesting little book in which the editors of SMITH magazine asked peopl...

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. Any suggestions?-- DW Hey, DW. Before we answer your question we have an obse...

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. How can I do that?-- RP Hey, RP. You know, a lot of you are probably sit...

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. Some of you might be concerned that this has finally happened: after all, th...

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; today it’s much warmer – 44 at last report – although it is raining. Of course, you know w...