How to remove the regular expression dollar format

Question

I am trying to remove the dollar format from the string '$ 1,109,889.23'. I tried using regex with:

"[^\\d]" 

but then I get commas.

Any help? Thanks in advance.

Answer 1

I am using ColdFusion. [^ \ D.] Works great as the eldarerathath mentioned above.

   <cfset amt = '$1,109,889.23'>
   <cfset newAmt = ReReplace(amt, "[^\d.]", "","ALL") >
   <cfoutput>#newAmt#</cfoutput>

Answer 2

You do not need regex for this.

Just use lsParseCurrency:

numericValue = lsParseCurrency('$1,109,889.23'); writeOutput(numericValue);

An example on trycf.com gives:

1109889.23

Leigh ... yer locale - , , . ()... , :

numericValue = lsParseCurrency('$1,109,889.23', 'en_us');

Answer 3

, $?

.

[^\d.]+

Answer 4

$ ( " " " ", ), \$. , ?

Answer 5

[\d,.]+ . - Rubular.

Answer 6

? ^\$

Answer 7

, , , , , "1,109,889.23". , use [\d,.\x20]+ ( , , , \x20, , ), . , , , [^\d,.\x20]. This will work for any currency format, not just those that use the dollar sign. It also allows for several types of punctuation, for example, allowing spaces to separate multiple numbers instead of commas. However, I agree with Tim Pitzker that regex may not be the best tool for this job.

Answer 8

In Java:

String newString = oldString.replaceAll("$", "");