how to extract multiple decimal value from a string

Question

0.00/5 (No votes)

See more:

Hi Friends,
How to extract decimal values from a string
My string format is given below

C#

string message = "Validated AMT_RETENT in TBILL_DETAIL Table: [E]64.45 - [A]64.46";

I need a function which return two values similar to these

C#

public static ArrayList GetTwoNumbers(string message)
       {
          ArrayList ar = new ArrayList();
          ar[0] =64.45;
          ar[1] = 64.46;
          return ar;
       }

Posted 13-Apr-15 1:43am

jinesh sam

Updated 13-Apr-15 1:57am

v3

Add a Solution

Comments

Style-7 13-Apr-15 7:58am

use regular expression ans delete all symbols except numbers and "-"
system.text.regularexpressions.regex.replace,
after use split function,
String.Split
and convert to double from string

Praveen Kumar Upadhyay 13-Apr-15 8:12am

Can you mention the output here, what output you want.

jinesh sam 14-Apr-15 11:59am

Thanks Praveen.. I got solution from Peter

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Peter Leow · Accepted Answer · 2015-04-13T02:01:00

Solution 1

Use Regex.
The Regex pattern in this case is

\d+.\d+

which means one or more number of digits (\d+) separated by a dot. If you want to have fixed number of decimal, say 2, then add {2} to the last one like this:

\d+.\d+{2}

Try to adapt from the example:

C#

using System;
using System.Text.RegularExpressions;

public class Program
{
    public static void Main()
    {
        string str = "Validated AMT_RETENT in TBILL_DETAIL Table: [E]64.45 - [A]64.46";
        Match match = Regex.Match(str, @"\d+.\d+");
        while (match.Success)
        {
            Console.WriteLine(match.Value);
            match = match.NextMatch();
        }
    }
}

The outcome will be:

VB

64.45
64.46

Learn more:
1. The 30 Minute Regex Tutorial[^]
2. http://www.dotnetperls.com/regex-match[^]

Posted 13-Apr-15 2:01am

Peter Leow

Updated 13-Apr-15 2:03am

v3

Comments

jinesh sam 13-Apr-15 8:36am

Thanks.. Its works fine :) One more doubt. If suppose the value is integer debug point not entering the while loop.How should i change the regex expression to accept both integer and decimal.

Maciej Los 13-Apr-15 9:03am

5ed!

Peter Leow 14-Apr-15 7:27am

Thank you, Maciej.

BillWoodruff 13-Apr-15 9:26am

+5 ... perfect !

johannesnestler 13-Apr-15 10:30am

until decimal separator isn't a dot...

Peter Leow 14-Apr-15 7:27am

Thank you, BillWoodruff.

jinesh sam 14-Apr-15 3:15am

To include integers
Match match = Regex.Match(str, @"\d+.\d+|\d+");

Peter Leow 14-Apr-15 3:34am

The original question is already solved. Post it as a new question and I will answer it.