CODEWITHSUNDEEP
c#regex
user3070072
user3070072

Reputation: 620

Extract specific values using Regex Expression

I'm trying to create an expression that extracts strings greater than 125 from a given string input.

var input = "YH300s, H900H, 234, 90.5, +12D, 48E, R180S, 190A, 350A, J380S";

Please view the link for further reference to my script/data example.

DonotFiddle_Regex example

Here is my current expression attempt (*):

Regex.Matches(input,@"(?!.*\..*)[^\s\,]*([2-5][\d]{2,})[^\s\,]*"))

From the above expression, the only output is 350A, J380S.

However I would like to extract the following output from the input string (see link above for further reference):

YH300s, H900H, R180S, 190A, 350A, J380S

Any further guide as to where I may be going wrong would be very much appreciated. Apology in advance if my context is not clear, as I am still novice in writing regex expressions.

Upvotes: 7

Views: 142

Answers (4)

ASh
ASh

Reputation: 35680

using System;
using System.Text.RegularExpressions;

public class Program
{
    public static void Main()
    {
        // an example of input
        var input = "YH300s, H900H, 234, 90.5, +12D, 48E, R180S, 190A, 350A, J380S";

        var parts = input.Split(new[]{", "}, StringSplitOptions.RemoveEmptyEntries);
        // regex for numbers (including negative and floating-point)
        var regex = new Regex(@"[-]?[\d]?[\.]?[\d]+");

        foreach(var part in parts)
        {
            // there can be many matches, e.g. "A100B1111" => "100" and "1111"            
            foreach(Match m in regex.Matches(part))
            {
                if (double.Parse(m.Value) > 125)
                {
                    Console.WriteLine(part);
                    break;
                }
            }                   
        }           
    }
}

output 

YH300s
H900H
234
R180S
190A
350A
J380S

Upvotes: 3

Wiktor Stribiżew
Wiktor Stribiżew

Reputation: 626845

You can make it even shorter with LINQ and a regex that would take care of double values (with - and +), even on OSes with a comma set as decimal separator:

var input = "YH300s, H900H, 234, 90.5, +12D, 48E, R180S, 190A, 350A, J380S";
var reslts = input.Split(new[] { ',' }, StringSplitOptions.RemoveEmptyEntries)
                 .Where( p.Any(n => Char.IsDigit(n)) && 
                         p => double.Parse(Regex.Match(p, @"[-+]?\d+(?:\.\d+)?").Value,
                 System.Globalization.CultureInfo.GetCultureInfo("en-us")) > 125).ToList();

Output:

enter image description here

The p.Any(n => Char.IsDigit(n)) part checks if we have any digits inside, then we match numbers with [-+]?\d+(?:\.\d+)? regex, and parse them as double values for further comparison.

Upvotes: 2

Tobias Maslowski
Tobias Maslowski

Reputation: 41

In your regex you wrote your numbers should start with one digit between 2 and 5 but in your desired result there is H900H, R180S, 190A which dont begin with one of those - so there is a Problem with what you actually want as result.

If you want to match strings with starting digits between 2-5 maybe try: @"\w*[2-5]\d{2,}\w*"

Upvotes: 1

karthik manchala
karthik manchala

Reputation: 13640

You can use the following regex (for numbers greater than 125) if you dont want to process the matches:

(?!.*\..*)[^\s\,]*(12[5-9]|1[3-9]\d|[2-9]\d{2}|\d{4,})[^\s\,]*
                  ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

Code:

var input = "YH300s, H900H, 234, 90.5, +12D, 48E, R180S, 190A, 350A, J380S";

foreach(var match in Regex.Matches(input,@"(?!.*\..*)[^\s\,]*(12[5-9]|1[3-9]\d|[2-9]\d{2}|\d{4,})[^\s\,]*"))
    {

        Console.WriteLine(match);

    }

See Demo on Fiddle

Upvotes: 2

Related Questions