Functions/Remove-QuotesFromCsv.ps1
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 |
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)]" } } |