How to extract the numerical part of a monetary value?

Question

How to extract the numerical part of a monetary value?

Asked 10 years, 1 month ago

Viewed 486 times

5

I have a string with the characters "R$ 1,000.60" and would like to extract only the characters "1,000.60".

I tried using regular expression, but I couldn’t reach my goal. I got to this:

    string valor = "";
    string texto = "R$ 1.000,60";

    Regex r = new Regex(@"^[0-9]*(?:\.[0-9]*)?$");
    foreach (Match m in r.Matches(texto))
        valor += m.Value;

Would anyone know how to solve this problem using regular expression or other technique?

+1 including by the goodwill of Edit :) We already have a good solution with Regex, and more alternatives may arise for you, the same Gypsy and/or other users.

– Bacco

2014/10/16 at 18:56
1

A split wouldn’t be enough?

– touchmx

2014/10/16 at 20:16
1

It is guaranteed that the format is always starting with R$ and then comes the number that matters in the format shown?

– Maniero

2014/10/16 at 23:39
The values will not always start with R$, and you can also change the field orders, for example 50R$

– cumpadi

2014/10/17 at 17:01

1 answer

Browser other questions tagged c# .net

You are not signed in. Login or sign up in order to post.

by Leonel Sanches da Silva • **88,623** points · Answer 1 · 2014-10-16T18:51:39+00:00

3

Change to the following:

 var r = new Regex(@"[0-9]*(\.[0-9]{3})*(,[0-9]{2})?$");

Here is a functional example of regular expression.

1

Why the use of var and not Regex?

– ptkato

2014/10/17 at 01:49
1

The compiler is able to intuit the type of the variable to be returned.

– Leonel Sanches da Silva

2014/10/17 at 01:55