Update: adapting the answer from Replace spaces only in between quotation marks to handle this problem.

Command:

echo '123,7,11,"$343,700.14","$34,928.63","$377,000.00","$15,421.92",19,2' |
awk -F\" '{OFS="\""; for (i = 2; i < NF; i += 2) gsub(/[$,]/,"",$i); gsub(/"/,""); print}'

Output:

123,7,11,343700.14,34928.63,377000.00,15421.92,19,2

The first gsub removes $s and ,s inside double quotes. The second remove the quotes themselves.

Leaving original answer below in case it helps.

If I understand you correctly a simple search and replace would do it

echo '"$1,234,567.89"' | sed 's/[$,"]//g'

Output 1234567.89.

What this does is that it substitute (s) characters matching ([]) $, , and " with nothing (empty between the last two /. The g flag makes it apply globally, replacing all instances (otherwise only the first instance in a line would be replaced).

How to apply this to the whole file depends on the format of the file. If there is nothing else in the file that has double quotes, dollar signs and comma, this should be good:

sed 's/[$,"]//g' /path/to/file

Update: adapting the answer from Replace spaces only in between quotation marks to handle this problem.

Command:

echo '123,7,11,"$343,700.14","$34,928.63","$377,000.00","$15,421.92",19,2' |
awk -F\" '{OFS="\""; for (i = 2; i < NF; i += 2) gsub(/[$,]/,"",$i); gsub(/"/,""); print}'

Output:

123,7,11,343700.14,34928.63,377000.00,15421.92,19,2

The first gsub removes $s and ,s inside double quotes. The second remove the quotes themselves.

Leaving original answer below in case it helps.

If I understand you correctly a simple search and replace would do it

echo '"$1,234,567.89"' | sed 's/[$,"]//g'

Output 1234567.89.

What this does is that it substitute (s) characters matching ([]) $, , and " with nothing (empty between the last two /. The g flag makes it apply globally, replacing all instances (otherwise only the first instance in a line would be replaced).

How to apply this to the whole file depends on the format of the file. If there is nothing else in the file that has double quotes, dollar signs and comma, this should be good:

sed 's/[$,"]//g' /path/to/file

If I understand you correctly a simple search and replace would do it

echo '"$1,234,567.89"' | sed 's/[$,"]//g'

Output 1234567.89.

What this does is that it substitute (s) characters matching ([]) $, , and " with nothing (empty between the last two /. The g flag makes it apply globally, replacing all instances (otherwise only the first instance in a line would be replaced).

How to apply this to the whole file depends on the format of the file. If there is nothing else in the file that has double quotes, dollar signs and comma, this should be good:

sed 's/[$,"]//g' /path/to/file

Update: adapting the answer from Replace spaces only in between quotation marks to handle this problem.

Command:

echo '123,7,11,"$343,700.14","$34,928.63","$377,000.00","$15,421.92",19,2' |
awk -F\" '{OFS="\""; for (i = 2; i < NF; i += 2) gsub(/[$,]/,"",$i); gsub(/"/,""); print}'

Output:

123,7,11,343700.14,34928.63,377000.00,15421.92,19,2

The first gsub removes $s and ,s inside double quotes. The second remove the quotes themselves.

Leaving original answer below in case it helps.

If I understand you correctly a simple search and replace would do it

echo '"$1,234,567.89"' | sed 's/[$,"]//g'

Output 1234567.89.

What this does is that it substitute (s) characters matching ([]) $, , and " with nothing (empty between the last two /. The g flag makes it apply globally, replacing all instances (otherwise only the first instance in a line would be replaced).

How to apply this to the whole file depends on the format of the file. If there is nothing else in the file that has double quotes, dollar signs and comma, this should be good:

sed 's/[$,"]//g' /path/to/file