POWERSHELL - Remove Quotation Marks from CSV for just one column

Question

I want to remove the quotation marks for only the first column of my csv file with powershell

So instead of:

"Username","Identifier"
"booker12","9012"   
"grey07","2070"

I want the result to be:

Username,"Identifier"
booker12,"9012" 
grey07,"2070

To remove all quotation marks the code would be

Import-Csv "test.csv" | ConvertTo-CSV -NoTypeInformation | % { $_ -Replace '"', ""} | Out-File C:\CSV_Tests\test.csv -fo -en ascii

But how to remove the marks just for the first column?

Thanks!

The -NoTypeInformation parameter suggest that you using an old version of PowerShell. I recommend you install the latest PowerShell version which has an new ConvertTo-Csv with a -quotefields parameter. — iRon
– iRon, Commented Oct 12, 2022 at 8:59
this is not possible, in our company we have to use an older version for several production reasons — user18209625
– user18209625, Commented Oct 12, 2022 at 9:01

iRon · Accepted Answer · 2022-10-22 06:14:44Z

As commented, it is recommended to install the latest PowerShell version which has a new ConvertTo-Csv/Export-Csv cmdlets with a -quotefields.
But as that appears not to be possible for your environment:

$Csv = @'
"Username","Identifier"
"booker12","9012"   
"grey07","2070"
'@ -Split '\r?\n'

$Csv -Replace '^"([^"]*)"', '$1'
Username,"Identifier"
booker12,"9012"
grey07,"2070"

Explanation:

For your file this means:

(Get-Content .\Test.csv) -Replace '^"([^"]*)"', '$1' |Set-Content .\Test.csv

Note that the parenthesis around (Get-Content .\Test.csv) are not recommended but required if you write back to the same file.

1 Answer 1