How to extract only numbers from a string

Question

0.00/5 (No votes)

See more:

I am having the following string

C#

<Polygon>
          <Vertex x="9352.7606" y="8250.6001" z="505.3871" />
          <Vertex x="9352.7573" y="8250.6001" z="505.3844" />
          </Polygon>

I want to get the string as

C#

9352.7606    8250.6001     505.3871    
9352.7573    8250.6001     505.3844

How to split as shown above and store in a new string

Posted 28-Mar-14 5:19am

KUMAR619

Updated 28-Mar-14 18:48pm

v3

Add a Solution

Comments

[no name] 28-Mar-14 11:25am

Write a regular expression. Just out of curiosity, why do you post and repost the same questions over and over?

KUMAR619 28-Mar-14 11:40am

Not working properly can any one get me a code

4 solutions

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)

Thomas Daniels · Answer 1 · 2014-03-28T05:39:00

Solution 2

First, add this using namespace; statement:

C#

using System.Text.RegularExpressions;

Then, try this:

C#

string str = "your string here";
MatchCollection matches = Regex.Matches(str, @"\d+(\.\d+)?");
List<string> numbers = new List<string>();
foreach (Match m in matches)
{
    numbers.Add(m.Value);
}

If you don't want a list of strings, but a list of doubles, try this:

C#

string str = "your string here";
MatchCollection matches = Regex.Matches(str, @"\d+(\.\d+)?");
List<double> numbers = new List<double>();
foreach (Match m in matches)
{
    numbers.Add(Double.Parse(m.Value, new System.Globalization.NumberFormatInfo() { NumberDecimalSeparator = "." }));
}

My regular expression \d+(\.\d+)? looks for numbers with and without decimal point. If you only want to match numbers with a decimal point, remove the parentheses and the question mark: \d+\.\d+

Posted 28-Mar-14 5:39am

Thomas Daniels

Updated 28-Mar-14 5:42am

v3

Comments

OriginalGriff 28-Mar-14 12:43pm

Thanks for that!
I was going to write up the same thing, almost identical, and you saved me a job...then I thought "why not use Linq?"
Because you can't that's why!
Then I thought a little more, and it's simple to convert...so (indirectly) thanks to you I have knocked up a quick tip that lets you use Linq with Regexes:
http://www.codeproject.com/Tips/751437/Using-Linq-with-Regular-Expression-results
Have a +5 for making my life a lot simpler in future!

Thomas Daniels 28-Mar-14 12:50pm

I've read your Tip, but it is not necessary to use your .AsEnumerable method on a MatchCollection or a GroupCollection in a foreach loop: foreach (Match m in matches) works fine; no need to call .AsEnumerable() on your matches object.

OriginalGriff 28-Mar-14 13:03pm

I realized that and removed it shortly after pressing "publish" :O
I'd left it there after a copy'n'paste from VS which was a touch over enthusiastic... :doh:
(It was the prototype tester for the extension methods before I checked the Linq versions)

Thomas Daniels 28-Mar-14 13:03pm

I see you removed the unnecessary statement, but I found something else: you said that MatchCollection doesn't implement IEnumerable, but it does implement IEnumerable, but not IEnumerable<T>. I think that needs to be fixed. Also, have a 5 for your tip for finding an easy way to use LINQ with regexes!

OriginalGriff 28-Mar-14 13:08pm

Bugger! Griff, you idiot, if it didn't implement IEnumerable, you couldn't use foreach with it... :O
Thanks! Fixed.

KUMAR619 29-Mar-14 0:43am

Thanks it is working but While storing using Stringbuilder I get all these values.

But when I try StringBuilder.Append(result.ToString()+"\t");

I dont get perfect output.

Please help me to solve this problem

Thomas Daniels 29-Mar-14 13:11pm

What to you mean by that? You need to use the regex on a string and not on a StringBuilder. Or do you mean something else?

KUMAR619 30-Mar-14 5:44am

my task is that get input from a string and separate all the valid numbers
then and add them in a list and concatenate all the string using string builder.

But If my string has three lines the result should so as in their corresponding line.

How to do this

Thomas Daniels 30-Mar-14 12:15pm

You can use String.Split to get an array of lines and then you can use the regex on all lines.

Rakesh Meel · Answer 2 · 2014-03-28T20:33:00

Solution 4

visit here...

http://labs.kaliko.com/2009/09/c-remove-all-non-numeric-characters.html[^]

Posted 28-Mar-14 20:33pm

Rakesh Meel

OriginalGriff · Answer 3 · 2014-03-28T05:33:00

Solution 1

Use a regular expression:

\d+\.\d+

Should do it...

Posted 28-Mar-14 5:33am

OriginalGriff

Comments

KUMAR619 28-Mar-14 11:41am

Sir I tried but its not working for me

Please give me a sample code

OriginalGriff 28-Mar-14 12:00pm

ProgramFOX has a code solution that should work.

OriginalGriff 28-Mar-14 12:40pm

Hah! Another solution: you can use regexes with Linq a lot more simply than I thought!
Using Linq with Regular Expression results[^]

KUMAR619 29-Mar-14 0:54am

Is there any way to split numbers and store them in a list for each line

List<string> lstString=new List<string>();

Now split lines and split each numbers by "\t"

So that in
lstSting[1]="9352.7606 8250.6001 505.3871"
lstSting[2]="9352.7573 8250.6001 505.3844"

Then I can append using StringBuilder.

First I need to split numbers of each line and store in corresponding list

Please help me to to solve this

OriginalGriff 29-Mar-14 5:34am

Yes - split the input text on '\n' and feed each line separately into the regex.
string.Split will do the first, and the second is just a simple loop, or a Linq statement.

KUMAR619 29-Mar-14 8:03am

Sir, Can you get me a code snippet

OriginalGriff 29-Mar-14 8:13am

Oh, come on! You can do this - you know you can!
You know how to use string.Split, don't you?

Matt T Heffron · Answer 4 · 2014-03-28T20:04:00

Solution 3

This looks like XML, so an XML centric solution might be appropriate. That way it is impedance matched to the problem space.
(I'm not used to doing this on my new Android tablet... so no code from me this time.)

Posted 28-Mar-14 20:04pm

Matt T Heffron