PowerTip: Using PowerShell to Convert raw Text to a Comma Separated columm

Doctor Scripto

Dr Scripto

Summary: Using PowerShell and a very simple Regular Expression to convert Random counts of spaces to a Comma

A picture containing scissors Description automatically generated

Hey Doctor Scripto! I have some string based output from a non PowerShell application. The output is good but I need to easily parse it. Is there a way to convert that data to something consistent like “Comma Separated?”

Why yes you can! This is something that is easily done with a regular expression. Using a simple example like this will identify all content with more than one blank space separating it, and replace it with a comma!

$SampleText=’Hello             This                      is   your      Good    Friend     Doctor                     Scripto’
$SampleText -replace ‘\s{2,}’ , ‘,’

I invite you to follow me on Twitter and Facebook. If you have any questions, send email to me at scripter@microsoft.com, or post your questions on the Official Scripting Forum. See you tomorrow. Until then, peace.

Your good friend, Doctor Scripto

PowerShell, Doctor Scripto, PowerTip, Dan Reist, Regular Expressions

 

Doctor Scripto
Dr Scripto

Scripter, PowerShell, vbScript, BAT, CMD

Follow Dr Scripto   

0 comments

    Leave a comment