Last Updated: December 03, 2019
·
153
· pwpearson

Find currency values and remove commas

Quick and dirty. I'm sure there are more general/concise ways to write this. Feel free to add your own version.

Regex

"(\$)([0-9]*),?([0-9]*),?([0-9]*)(\.?)([0-9]*+ *)"

Replace

"$1$2$3$4$5$6"

Ex: Finds "$999,999,999.99" literal and replaces it with "$999999999.99"