Showing tag results for Windows PowerShell

Hey, Scripting Guy! How can I use a disconnected recordset in Windows PowerShell? I’m able to create the recordset without any problem, but I can’t figure out how to reference the fields and values in that recordset.-- JVDL Hey, JVDL. Well, we must say, we’re impressed by how cool, calm, and collected you are. After all, today is the opening day...

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 understand that I can use Windows PowerShell and the Get-Unique cmdlet to determine which items are unique in a collection. However, I want to do the opposite: I want to determine which items are not unique in a collection. How can I do that?-- YE Hey, YE. You know, yesterday afternoon, just as he was getting ready to head f...

Hey, Scripting Guy! Using Windows PowerShell, how can I replace all the asterisks in a text file with some other character?-- RC Hey, RC. You know, a lot of people ask the Scripting Guy who writes this column, “How do you do it? How do you manage to write a new column each and every day?” (Of course, lots of other people ask him why h...

Hey, Scripting Guy! Awhile back you showed us how we could use Windows PowerShell to retrieve data from a Microsoft Access database. I’m now trying to add data to a database using PowerShell, but I can’t get the script to work. Any chance you could show me how to add a record to a database using Windows PowerShell?-- AB Hey, AB. Before we start ...