Take out numeric from string

[Rahul_Jawahirani]

Hi Guys,

100/200/20/11982 (19 items)

I want to take out numeric value between braces from the above mentioned string.

Please guide me on this.

Thanks in advance

[prasath17 (Guru)]

@Rahul_Jawahirani - Please try this pattern…

Output = Regexvar(0).groups(1).tostring

Hope this helps…

[Pravin_Patil1 (Pravin Patil)]

@Rahul_Jawahirani

Another way would be

System.Text.RegularExpressions.Regex.Match(varStr,"(?<=[(])(\d|.){1,4}").Value

[Rahul_Jawahirani]

It worked…

Thanks @Pravin_Patil1

[Adrian_Star (Adrian Starukiewicz)]

Hi,
you can try:

output = System.Text.RegularExpressions.Regex.Match(your_String, "(?<=\()\d{1,}").Value

output = String
your_String= String

Or:

output = System.Text.RegularExpressions.Regex.Match(your_String, "(?<=\()\d{1,}(?=\s+items\))").Value

output = String
your_String= String

[Rahul_Jawahirani]

It worked…

Thanks alot@Adrian_Star

[postwick (Paul Ostwick)]

@Rahul_Jawahirani

100/200/20/11982 ( 19 items)

CInt(“100/200/20/11982 (19 items)”.Split(“(”)(1).Split(" ")(0))

Splits on the ( and takes the second part of the split then splits again on the space and takes what’s before the space. Converts the resulting value to integer.