Remove character from column of CSV

Question

I have a file similar to the following:

random,test123,MyCompany, Inc.
hello,12345,TestCompany, LLC

I want to remove the commas from the third column so I'd have something like this:

random,test123,MyCompany Inc.
hello,12345,TestCompany LLC

How would I do this?

If the first two "columns" contain a comma somewhere, then both answers below (and any others that are general enough to be useful) will fail. If that's the case, then you will have to do some manual editing. Otherwise, either answer works fine. — NickD, Sep 20, 2017 at 12:28

Community · Accepted Answer · 2020-06-11 14:16:50Z

5

This is easy with sed:

sed 's/,//3' file

If you want to directly apply the modifications in your input file, then run:

sed -i 's/,//3' file

CommunityBot

1

answered Sep 20, 2017 at 11:32

seshoumara

8525 silver badges7 bronze badges

Add a comment |

RomanPerekhrest · Accepted Answer · 2017-09-20 11:50:08Z

0

With awk:

awk -F, '{print $1,$2,$3$4}' OFS=',' file

The output:

random,test123,MyCompany Inc.
hello,12345,TestCompany LLC

answered Sep 20, 2017 at 11:50

RomanPerekhrest

29.9k4 gold badges45 silver badges67 bronze badges

Add a comment |

2 Answers 2