# ============================================================================================== # # Microsoft PowerShell Source File -- Created with SAPIEN Technologies PrimalScript 2007 # # NAME: out-csv.ps1 # # AUTHOR: Jeffery Hicks , SAPIEN Technologies, Inc. # DATE : 4/1/2009 # # COMMENT: Create a comma separated string from input # # Sample usage # $a="a",1,"b","jeff",4 # $a | out-csv # get-service | where {$_.status -eq "running"} | foreach {$_.name} | out-csv # # DISCLAIMER AND WARNING: # THIS CODE AND INFORMATION ARE PROVIDED "AS IS" WITHOUT WARRANTY OF ANY # KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE # IMPLIED WARRANTIES OF MERCHANTABILITY AND/OR FITNESS FOR A PARTICULAR PURPOSE. # TEST THOROUGHLY IN A NON-PRODUCTION ENVIRONMENT. IF YOU DON'T KNOW WHAT THIS # SCRIPT WILL DO...DO NOT RUN IT! # ============================================================================================== Function out-csv { BEGIN { #probably not necessary [string]$csv="" } PROCESS { #force each item to be a string and trim any spaces $item=($_ | out-string).Trim() if ($csv) { $csv+="," + $item } else { #first item in the string $csv=$item } } END { #send the comma separated string into the pipeline write $csv } }