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:123,7,11,$343,700.14,$34,928.63,$377,000.00,$15,421.92,19,2I 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.
Change currency format to generic number using sed
sed;awk;regular expression