January 26th, 2016

PowerTip: Import colon-delimited file with PowerShell

Doctor Scripto
Doctor Scripto
Scripter

Summary: Learn how to use Windows PowerShell to import a file that uses a colon as a delimiter.

Hey, Scripting Guy! Question How can I use Windows PowerShell to import a file that is delimited with a colon instead of a comma?

Hey, Scripting Guy! Answer Use the Import-CSV cmdlet and specify the colon as the delimiter, for example:

import-csv -Path C:\fso\applog.csv -Delimiter ':'

Category
Scripting
Topics
PowerTipScripting Guy!Windows PowerShell

Author

Doctor Scripto

The "Scripting Guys" is a historical title passed from scripter to scripter. The current revision has morphed into our good friend Doctor Scripto who has been with us since the very beginning.

0 comments

Discussion are closed.

Read next