How to Replace comma in double quotes Using PowerShell

I have CSV file which has following line
111,222," 1,876,890"

I would like to have output as follows
111,222,1876890

How can I do this in Power Shell?
SURESH0518Asked:
Who is Participating?
 
oBdACommented:
If the csv file has a header line:
$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

Open in new window


If it does not have a header line:
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

Open in new window

2
 
aikimarkCommented:
You can cast the field as a number, rather than doing any string operations.
Example:
PS C:\Users\Mark> [int]" 1,876,890"
1876890

Open in new window

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.

Advertise Here