Programming Forums - View Single Post

Celsoft · Aug 27th, 2008, 6:53 AM

This must have been done a million times but I can't seem to find the solution

I have a "normal" comma-separated file (.csv) with some text fields in double-quotes. These fields MAY contain a comma, which should be changed to a space.

I want to use sed or awk (or gawk) to zap the unwanted commas, leaving the legit delimiting commas intact.

Any help appreciated ... TA

Aug 27th, 2008, 6:53 AM	#1
Celsoft Newbie Join Date: Aug 2008 Posts: 3 Rep Power: 0	Remove commas from text fields in .csv This must have been done a million times but I can't seem to find the solution I have a "normal" comma-separated file (.csv) with some text fields in double-quotes. These fields MAY contain a comma, which should be changed to a space. I want to use sed or awk (or gawk) to zap the unwanted commas, leaving the legit delimiting commas intact. Any help appreciated ... TA