Functions/Remove-QuotesFromCsv.ps1
|
function Remove-QuotesFromCsv { <# .SYNOPSIS Removes quotes from a CSV data set. Can optionally set $Delimiter to another character. .DESCRIPTION Removes quotes from a CSV data set. Can optionally set $Delimiter to another character. .PARAMETER CSV The CSV string data. .PARAMETER Delimiter A single [char] delimiter. Defaults to ','. Can be set to tab character "`t", or any other .EXAMPLE '"f1","f2"' | Remove-QuotesFromCsv Will return f1,f2 .EXAMPLE "`"f1`"`t`"f2`"" | Remove-QuotesFromCsv -Delimiter "`t" -verbose Will return VERBOSE: Starting Remove-QuotesFromCsv f1 f2 VERBOSE: Ending Remove-QuotesFromCsv .EXAMPLE $array | ConvertTo-Csv -NoTypeInformation | Remove-QuotesFromCsv Will return blah,blah,blah .INPUTS None .OUTPUTS [string[]] .LINK ConvertFrom-Csv #> [CmdletBinding(ConfirmImpact='Low',SupportsShouldProcess)] [OutputType([string[]])] [Diagnostics.CodeAnalysis.SuppressMessageAttribute('PSReviewUnusedParameter','')] param( [parameter(ValueFromPipeLine,HelpMessage='Add help message for user',Mandatory)] [string[]] $csv, [parameter()] [char] $Delimiter = ',' ) begin { Write-Verbose -Message "Starting [$($MyInvocation.Mycommand)]" } process { foreach ($line in $csv) { write-verbose -Message ('Current line: ' + $line) $line | foreach-object { $_ -replace ('"' + $Delimiter + '"'), $Delimiter} | foreach-object { $_ -replace ('^"'),''} | foreach-object { $_ -replace '"$',''} } } end { Write-Verbose -Message "Ending [$($MyInvocation.Mycommand)]" } } |