Do more with
$Col = '<Name of Column 3>'
Import-Csv -Path C:\Temp\input.csv |
ForEach-Object {$_.$Col = $_.$Col.Replace(',', '').Trim(); $_} |
ConvertTo-Csv -NoTypeInformation |
ForEach-Object {$_.Replace('"', '')} |
Set-Content -Path C:\Temp\output.csv
Import-Csv -Path C:\Temp\input.csv -Header Col1, Col2, Col3 |
ForEach-Object {$_.Col3 = $_.Col3.Replace(',', '').Trim(); $_} |
ConvertTo-Csv -NoTypeInformation |
Select-Object -Skip 1 |
ForEach-Object {$_.Replace('"', '')} |
Set-Content -Path C:\Temp\output.csv
Premium Content
You need an Expert Office subscription to comment.Start Free Trial