Regex match number in string C#

Question

I am trying to get the total price from a receipt with Regex.

The formatting is:

TOTAL     15.40

The goal is only to get the price out of the string.

I started with TOTAL[ .0-9], but this only returned the word TOTAL.

I googled around and putted this one together but can't get it to work:

TOTAL(\\s+)(?<value>[.0-9]+)

I have made the following code:

sRegex = "TOTAL(\\s+)(?<value>[.0-9]+)";    
Match match = Regex.Match(this.sHTMLResult, sRegex, RegexOptions.None);
if (match.Success)
    Console.Out.WriteLine("regex good");
else
    Console.Out.WriteLine("regex fail");

But the regex doesn't return a success.

I try to get it out of a HTML file formatted like this:

TOTAL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;15.40

Works for me. I get a match with the capture group containing 15.40. Check your inputs. — Oded
– Oded, Commented Mar 12, 2013 at 10:15
Good point, I tested with only the text and it works, but I try to get it out of a HTML file formatted like this: TOTAL 15.40 Probably the regex doesn't see as space — Gerard van den Bosch
– Gerard van den Bosch, Commented Mar 12, 2013 at 10:21
txt2re.com should be your new friend. The outputted regex isn't perfect, but it gives you a good starting point. — RoadieRich
– RoadieRich, Commented Mar 12, 2013 at 10:21
There you go. Don't use regex to parse HTML, or at least convert HTML to regular text before hand. — Oded
– Oded, Commented Mar 12, 2013 at 10:22

Oded · Accepted Answer · 2013-03-12 10:26:24Z

1

Your initial regular expression works fine with the supplied text:

TOTAL(\\s+)(?<value>[.0-9]+)

However, as you indicated in comments, this is from HTML and contains the character entities for no break spaces, so you need to account for those as well:

TOTAL(\\s+|(&nbsp;)+)(?<value>[.0-9]+)

answered Mar 12, 2013 at 10:26

Oded

501k102 gold badges900 silver badges1k bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Gerard van den Bosch Over a year ago

Thank you for the example, I took your suggestion from the comments already and converted it to plain text first before doing the regex and that works great.

Richard Fresow · Accepted Answer · 2013-03-12 10:19:28Z

1

You might use:

"TOTAL *(\d*.\d*)"

answered Mar 12, 2013 at 10:19

Richard Fresow

112 bronze badges

1 Comment

Oded Over a year ago

In .NET \d will match on all numerals, not only [0-9] (so, Arabic numerals will match, for example).

Joel · Accepted Answer · 2013-03-12 10:47:03Z

1

(?(\b.*\b\s)([0-9.]*[0-9])) should work.

I would recommend you to use the Regex hero online editor which is at least really helpful for me.

edited Mar 12, 2013 at 10:47

answered Mar 12, 2013 at 10:21

Joel

4,8928 gold badges50 silver badges71 bronze badges

1 Comment

Oded Over a year ago

Why is this better than the regex from the OP?

Eli Arbel · Accepted Answer · 2013-03-12 10:19:40Z

0

Your regex works (check your input as suggested), but it has a small bug: it would capture any combination of digits and dots (like 333.3.2.22....) A better one would be:

TOTAL\s+(?<value>\d+\.\d+)

answered Mar 12, 2013 at 10:19

Eli Arbel

22.8k3 gold badges48 silver badges73 bronze badges

Comments

bash.d · Accepted Answer · 2013-03-12 10:16:51Z

-2

If you have only a single whitespace between TOTAL and the amount you can use a whitespace in the regex. Additionally, try this:

sRegex = "TOTAL ([0-9]+\.[0-9]+)";

See here for the MSDN reference.

answered Mar 12, 2013 at 10:16

bash.d

13.3k3 gold badges33 silver badges42 bronze badges

1 Comment

Oded Over a year ago

You will note that the regex posted by the OP is fine. If that isn't matching, why would your match any better?

Collectives™ on Stack Overflow

Regex match number in string C#

5 Answers 5

1 Comment

1 Comment

1 Comment

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

1 Comment

1 Comment

1 Comment

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related