text qualifier in awk??

[pavNell]

I have a comma delimited text file. The text for each field is enclosed in "". However, one of the fields contains a comma (to separate persons last name from first name). I'd like to replace the comma field separators to a colon, but leave the comma intact in the "persons name" field. Is this possible in [gn]awk? I've provided an example record...

"Smith, Joe","Development","555-1212","123 Main St"

Thanks.

 

[dickiebird]

Use sed to look for and replace all ","
sed 's/\&quot;,\&quot;/\&quot;:\&quot;/g' < infile > outfile


HTH
Dickie Bird (-)))

 

[pavNell]

That's great!! Thanks Mr. Bird!

 

[dickiebird]

You're welcome !
sed 's/&quot;,&quot;/&quot;:&quot;/g' infile > outfile would have done - I often escape( using \) things I don't actually need to !
Cheers


Dickie Bird (-)))