Welcome to TechNet Blogs Sign in | Join | Help

Browse by Tags

All Tags » CSV files   (RSS)

Hey, Scripting Guy! Quick-Hits Friday: The Scripting Guys Respond to a Bunch of Questions (05/01/09)

How Can I Get Help with Scripts I’m Writing? Hey, Scripting Guy! I am a novice scripter but am being diligent about learning more specifically around VBScript. I am following the Microsoft Press book, Windows Scripting Self-Paced Learning Guide , and

Hey, Scripting Guy! How Can I Convert a Tab-Delimited File to a Comma-Separated Value File?

Hey, Scripting Guy! I have this tab-delimited file that was produced by a report from an old database application. All it knows how to do is make a tab-delimited file. I hate this format, and our other applications do too. I have been opening the thing

Hey, Scripting Guy! How Can I Create Users from a CSV File?

Hey, Scripting Guy! In your last article, you showed how to create random passwords for users and how to write that password out to a CSV file. You said if anyone asked that you would show how to use that CSV file and create a user from it. Well, here

Hey, Scripting Guy! How Can I Read a CSV File?

Hey, Scripting Guy! I am new to scripting, but I have been tasked with creating a script anyway. What I need to do is to read in a CSV file and then perform an operation on each line in the file. I do not know what the correct cmdlet is or what action

Hey, Scripting Guy! How Can I Modify a .CSV File and Then Import That File into Microsoft Excel?

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, when I import this file I need to format

Hey, Scripting Guy! How Can I Use Windows PowerShell to Sort a CSV File?

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

How Can I Copy Selected Columns From a CSV File to an Excel 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

How Can I Create a CSV File?

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
 
Page view tracker