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

Aug 18, 2014
0
0

PowerShell Mini-Scripting Games 2014: Answer 1

Doctor Scripto
Doctor Scripto

Summary: Here is the answer to Problem 1 in Windows PowerShell Mini-Scripting Games 2014. Microsoft Scripting Guy, Ed Wilson, is here. Here is an answer to Problem 1 in Windows PowerShell Mini-Scripting Games 2014. Last week, I posted the complete Problem 1 description and task outline. Problem one synopsis You are reading a CSV file that was ...

Scripting Guy!Windows PowerShellscripting techniques
Feb 4, 2014
1
0

Use PowerShell to Create CSV File to Open in Excel

Doctor Scripto
Doctor Scripto

Summary: Microsoft Scripting Guy, Ed Wilson, talks about exporting a directory list to a CSV file and opening the file in Microsoft Excel with Windows PowerShell.  Hey, Scripting Guy! I have a lot of music files that reside in nested folders. I would like to be able to look at the file information in Microsoft Excel so that I can find, for ...

Scripting Guy!Windows PowerShellscripting techniques
Nov 21, 2013
0
0

Use PowerShell to Remove Data from CSV File

Doctor Scripto
Doctor Scripto

Summary: Guest blogger, Matt Tisdale, talks about using Windows PowerShell to remove data from a .csv file. Microsoft Scripting Guy, Ed Wilson, is here. Welcome back guest blogger, Matt Tisdale… Last night a geoscientist told me that he has almost 900 .csv files, and he needs to remove two columns of data from them. He has used Windows ...

Scripting Guy!Windows PowerShellguest blogger
Jul 23, 2013
0
0

Write Users and Proxy Addresses to CSV by Using PowerShell

Doctor Scripto
Doctor Scripto

Summary: Microsoft Scripting Guy, Ed Wilson, talks about writing all proxy addresses and user names to a CSV file by using Windows PowerShell.  Hey, Scripting Guy! Yesterday’s blog post, Export User Names and Proxy Addresses to CSV File, showed me an easy way to get a couple of proxy addresses from Active Directory, but all users do not ...

Scripting Guy!Windows PowerShellscripting techniques
Jul 22, 2013
0
0

Export User Names and Proxy Addresses to CSV File

Doctor Scripto
Doctor Scripto

Summary: Microsoft Scripting Guy Ed Wilson talks about using Windows PowerShell to export user names and proxy addresses to a CSV file from Active Directory.  Hey, Scripting Guy! I am trying to produce a report of our users in Active Directory and their associated proxy addresses. I want it in Excel, so I am using the Export-CSV cmdlet. The ...

Scripting Guy!Windows PowerShellscripting techniques