I am working on a large csv file with all coma separated entries. The entire document is composed of plain numbers, except for a few columns reflecting currencies that are formatted as text. For example, one such entry may look like
"$12,345.67" and another one like
"$1,234,567.89" (double quote symbols are also included as part of the entries). Here is an example of a full record (one single line) of data:
I would like to do some processing on this data file and therefore, I want to reformat such text fields to become plain numbers (i.e., getting rid of double quotes and comas). I think a regex pattern replacement with
sed should do the job for me, but I am not sure what that regular expression looks like at all. Any idea would be much appreciated.