Regex to match integers, decimals and fractions

Question

I'm looking for a regular expression that can match integers, decimals and fractions from a string:

Here are some examples

11.325 x 55.65
11x13
11”x13”
11” x 13”
11 3/8 x 15 7/8 
11 3/8” x 15 7/8“

Explanation of above examples:

1. Two decimals
2. Two integers
3. Two integers with quote to represent inches
4. Same as above but with spaces
5. Two integers each followed by a fraction
6. Same as above with a quote after fraction for inches

So far I have come up with code that will match any numeric values, i.e. integers and decimals, but I'm stuck on the fractions.

Dim matches = Regex.Matches(curCellVal + "", "[\d.]+")

The above code gives me 6 matches for 11 3/8” x 15 7/8“, I need it to give me 2.

I'm not competent with regex so any help would be much appreciated.

My language of preference is VB.net.

Answer 1

Give this one a shot:

(\d+[\/\d. ]*|\d)

http://regex101.com/r/oO9yI9

In the future, I'd suggest making your question more clear so we can actually understand what you're trying to do -- provide inputs, expected outputs, and include the programming language you're using.

vb.net is PCRE compliant, so you should be able to use this:

Dim regex As Regex = New Regex("(\d+[\/\d. ]*|\d)")
Dim match As Match = regex.Match("11.325 x 55.65")
If match.Success Then
    Console.WriteLine(match.Value)
    # this matches, so you'll get a value
End If

Answer 2

This regular expression should work:

@"\d+(\.\d+|\s+\d+/\d+)?"

This matches any sequence of one or more digits, optionally followed by an either a . followed by one or more digits or a sequence of one or more whitespace characters, followed by one or more digits, followed by a /, followed by one or more digits.

For example:

Dim inputs = New String() { _
    "11.325 x 55.65", _
    "11x13", _
    "11””x13””", _
    "11”” x 13””", _
    "11 3/8 x 15 7/8 ", _
    "11 3/8”” x 15 7/8““" }
For Each input in inputs
    Console.Write(input + ": ")
    For Each match as Match in Regex.Matches(input, "\d+(\.\d+|\s+\d+/\d+)?")
        Console.Write(" (" + match.Value + ") ")
    Next
    Console.WriteLine()
Next

Produces the output:

11.325 x 55.65:  (11.325)  (55.65) 
11x13:  (11)  (13) 
11"x13":  (11)  (13) 
11" x 13":  (11)  (13) 
11 3/8 x 15 7/8 :  (11 3/8)  (15 7/8) 
11 3/8" x 15 7/8":  (11 3/8)  (15 7/8)