Removing field from csv file 1

[ianicr]

I have a csv file with names and addresses eg.
Mr,Smith,1,New Street,Birmingham

Is there an easy way of removing the third comma to make the file
Mr,Smith,1 New Street, Birmingham

Thanks

 

[Annihilannic]

sed 's/,/ /3' filename > output should do it (a trick I learned from SamBones).


Annihilannic.

 

[ianicr]

You're a star. Thanks a lot

 

[ianicr]

One last thing, how do you do it with a tab delimited file?

 

[dickiebird]

sed 's/,/ /' infile > outfile
will replace the first , found with a space, irrespective of the delimiter

Dickie Bird (-)))

 

[PHV]

With a Tab delimited file:

sed 's/   / /3' filename > output
       ^^^
       Single Tab char

Hope This Help
PH.