PowerShell script to replace comma's in CSV file with nothing [duplicate]

Question

Below is my script to replace comma's in an existing CSV file. The delimiter used is | The script works perfectly fine but takes a long time to replace. Do we have a faster approach to replace all instances of comma's with nothing.

$inform = Get-Content C:\product.csv
                $inform | % { 
                $info = $_.ToString().Replace(",","")                
                $info  | Out-file C:\product_comma_replaced.csv -Append 
                }

Input CSV:

1|Test,ABC|Test,LMN

Output CSV:

1|TestABC|TestLMN

So, do you want to remove commas, or do you want to put fields with commas in double quotes? Which is it? — Ansgar Wiechers
– Ansgar Wiechers, Commented Jul 11, 2017 at 8:16
put fields with commas in double quotes - This is a separate requirement, don't have the answer yet I got the answer for this post(replace comma's with nothing), it was indeed a duplicate. — Joseph
– Joseph, Commented Jul 11, 2017 at 8:29

Chetan Kulkarni · Accepted Answer · 2017-07-11 07:37:38Z

0

Try This,

$inform = Get-Content C:\product.csv
$inform.ToString()
$y=$inform -replace ',' -replace ''
 $y  | Out-file C:\product_comma_replaced.csv -Append

answered Jul 11, 2017 at 7:37

Chetan Kulkarni

4044 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

vonPryz Over a year ago

This is not recommended an approach if working with large (100s of megabytes to gigabytes or larger) files.

Chetan Kulkarni Over a year ago

I agree Sir,But Looking at the problem defination i presumed it to be lesser than a mb/Max 10 mb and its the easiest and quickest fix i feel.Just giving out a simple fix to the simple problem. :)

Chetan Kulkarni Over a year ago

1048576 rows csv translates to 600 mb,I Hope @joseph Doesnt have that huge data

Collectives™ on Stack Overflow

PowerShell script to replace comma's in CSV file with nothing [duplicate]

1 Answer 1

3 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Linked

Related