Removing Dollar and comma from string

Question

How can we remove dollar sign ($) and all comma(,) from same string? Would it be better to avoid regex?

String liveprice = "$123,456.78";

score 33 · Accepted Answer · edited Sep 25 '19 at 07:47

33

do like this

NumberFormat format = NumberFormat.getCurrencyInstance();
Number number = format.parse("\$123,456.78");
System.out.println(number.toString());

output

123456.78

edited Sep 25 '19 at 07:47

Rahul Mahadik

11,668
6
41
54

answered Dec 03 '13 at 12:38

Prabhakaran Ramaswamy

25,706
10
57
64

I really want this. You make my day. Thanks :) – Varun Vishnoi Dec 03 '13 at 12:53
My value is 1,000 then is gives java.text.ParseException: Unparseable number: "1,000" (at offset 5) – Dilip Jun 03 '16 at 06:46
1

Is '$' the currency character for your local? – NomadMaker May 22 '20 at 09:07
wtf: `java.text.ParseException: Unparseable number: "$39.39"` – MarkHu Sep 17 '21 at 19:52
Without specifying a locale, I got this error: `java.text.ParseException: Unparseable number: "$1,234.56"` --but this made it work: `NumberFormat.getCurrencyInstance(Locale.US).parse(sourceStr)` – MarkHu Sep 17 '21 at 23:12

Masudul · Answer 2 · 2013-12-03T12:42:22.917

26

Try,

String liveprice = "$123,456.78";
String newStr = liveprice.replaceAll("[$,]", "");

replaceAll uses regex, to avoid regex than try with consecutive replace method.

 String liveprice = "$1,23,456.78";
 String newStr = liveprice.replace("$", "").replace(",", "");

edited Dec 03 '13 at 12:42

answered Dec 03 '13 at 12:36

Masudul

21,823
5
43
58

he wants to avoid regex – Deepak Bhatia Dec 03 '13 at 12:38
2

OP said "Would be better if we avoid regex." – René Link Dec 03 '13 at 12:38

Prateek · Answer 3 · 2013-12-03T12:47:45.270

3

Without regex, you can try this:

String output = "$123,456.78".replace("$", "").replace(",", "");

edited Dec 03 '13 at 12:47

answered Dec 03 '13 at 12:42

Prateek

6,785
2
24
37

This will put gap `' '` between number. – Masudul Dec 03 '13 at 12:45

score 2 · Answer 4 · answered Dec 03 '13 at 12:35

2

Here is more information Oracle JavaDocs:

liveprice = liveprice.replace("X", "");

answered Dec 03 '13 at 12:35

Faraday

2,904
3
23
46

Vishal Suthar · Answer 5 · 2013-12-03T12:54:27.090

2

Will this works?

String liveprice = "$123,456.78";
String newStr = liveprice.replace("$", "").replace(",","");

Output: 123456.78

Live Demo

Better One:

String liveprice = "$123,456.78";
String newStr = liveprice.replaceAll("[$,]", "")

Live Demo

edited Dec 03 '13 at 12:54

answered Dec 03 '13 at 12:35

Vishal Suthar

17,013
3
59
105

@Jesper Is that fine now? – Vishal Suthar Dec 03 '13 at 12:37

Deepak Bhatia · Answer 6 · 2013-12-03T12:47:31.720

2

Just use Replace instead

String liveprice = "$123,456.78";
String output = liveprice.replace("$", "");
output = output .replace(",", "");

edited Dec 03 '13 at 12:47

answered Dec 03 '13 at 12:37

Deepak Bhatia

6,230
2
24
58

score 2 · Answer 7 · answered Aug 04 '19 at 17:19

2

In my case, @Prabhakaran's answer did not work, someone can try this.

String salary = employee.getEmpSalary().replaceAll("[^\\d.]", "");
Float empSalary = Float.parseFloat(salary);

answered Aug 04 '19 at 17:19

minato

2,028
1
18
30

While this does work, some might criticize regEx as being slow and tricky. Of course, as we see, figuring out lib calls and options is tricky also. An all-purpose powerful lib, is in many cases an intricate puzzle that seems unable to cover the problem at-hand. – MarkHu Sep 17 '21 at 23:16

score 0 · Answer 8 · answered Dec 03 '13 at 12:39

Is a replace really what you need?

public void test() {
  String s = "$123,456.78";
  StringBuilder t = new StringBuilder();
  for ( int i = 0; i < s.length(); i++ ) {
    char ch = s.charAt(i);
    if ( Character.isDigit(ch)) {
      t.append(ch);
    }
  }
}

This will work for any decorated number.

score 0 · Answer 9 · answered Nov 18 '14 at 09:27

Example using Swedish Krona currency

String x="19.823.567,10 kr";

        x=x.replace(".","");
        x=x.replaceAll("\\s+","");
        x=x.replace(",", ".");
        x=x.replaceAll("[^0-9 , .]", "");

System.out.println(x);

Will give the output ->19823567.10(which can now be used for any computation)

score 0 · Answer 10 · edited May 22 '20 at 09:50

0

import java.text.NumberFormat

def currencyAmount = 9876543.21 //Default is BigDecimal
def currencyFormatter = NumberFormat.getInstance( Locale.US )

assert currencyFormatter.format( currencyAmount ) == "9,876,543.21"

Don't need getCurrencyInstance() if currency is not required.

edited May 22 '20 at 09:50

Sardar Usama

19,536
9
36
58

answered May 22 '20 at 09:01

Ravindra-Ravi Verma

407
4
10

score -1 · Answer 11 · edited May 27 '18 at 16:40

-1

I think that you could use regex. For example:

"19.823.567,10 kr".replace(/\D/g, '')

edited May 27 '18 at 16:40

Tim Diekmann

7,755
11
41
69

answered May 27 '18 at 15:22

Bruno Lopes Malafaia

1

Removing Dollar and comma from string

11 Answers11

Live Demo

Live Demo

Linked

Related