{"id":1781,"date":"2014-03-22T11:59:00","date_gmt":"2014-03-22T11:59:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/heyscriptingguy\/2014\/03\/22\/powertip-convert-output-to-use-specific-delimiter\/"},"modified":"2014-03-22T11:59:00","modified_gmt":"2014-03-22T11:59:00","slug":"powertip-convert-output-to-use-specific-delimiter","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/scripting\/powertip-convert-output-to-use-specific-delimiter\/","title":{"rendered":"PowerTip: Convert Output to Use Specific Delimiter"},"content":{"rendered":"<p><b>Summary<\/b>: Use Windows PowerShell to convert output to a specific delimiter.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/29\/2019\/02\/q-for-powertip.jpg\" alt=\"Hey, Scripting Guy! Question\" \/>&nbsp;How can I use Windows PowerShell to select process name and paged system memory, plus separate the output with a colon?<\/p>\n<p style=\"margin-left:30px\"><img decoding=\"async\" src=\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/29\/2019\/02\/a-for-powertip.jpg\" alt=\"Hey, Scripting Guy! Answer\" \/>&nbsp;Use the&nbsp;<b>Get-Process<\/b>&nbsp;cmdlet to retrieve the process information, select the name, <br \/>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; add the&nbsp;<b>PagedSystemMemorySize&nbsp;<\/b>property, pipe the output to the&nbsp;<b>ConvertTo-CSV<\/b>&nbsp;cmdlet, <br \/>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; and specify the delimiter as&nbsp;<b>&ldquo;:&rdquo;<\/b>:<\/p>\n<p style=\"margin-left:90px\">Get-Process | select name, PagedSystemMemorySize | ConvertTo-Csv -Delimiter &quot;:&quot;<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/29\/2019\/02\/7610.Dr.ScriptoForTips.jpg\"><img decoding=\"async\" src=\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/29\/2019\/02\/7610.Dr.ScriptoForTips.jpg\" alt=\" \" border=\"0\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Summary: Use Windows PowerShell to convert output to a specific delimiter. &nbsp;How can I use Windows PowerShell to select process name and paged system memory, plus separate the output with a colon? &nbsp;Use the&nbsp;Get-Process&nbsp;cmdlet to retrieve the process information, select the name, &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; add the&nbsp;PagedSystemMemorySize&nbsp;property, pipe the output to the&nbsp;ConvertTo-CSV&nbsp;cmdlet, &nbsp; [&hellip;]<\/p>\n","protected":false},"author":596,"featured_media":87096,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[356,3,45],"class_list":["post-1781","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-scripting","tag-powertip","tag-scripting-guy","tag-windows-powershell"],"acf":[],"blog_post_summary":"<p>Summary: Use Windows PowerShell to convert output to a specific delimiter. &nbsp;How can I use Windows PowerShell to select process name and paged system memory, plus separate the output with a colon? &nbsp;Use the&nbsp;Get-Process&nbsp;cmdlet to retrieve the process information, select the name, &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; add the&nbsp;PagedSystemMemorySize&nbsp;property, pipe the output to the&nbsp;ConvertTo-CSV&nbsp;cmdlet, &nbsp; [&hellip;]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/1781","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/users\/596"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/comments?post=1781"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/1781\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media\/87096"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media?parent=1781"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=1781"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=1781"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}