How to tell regex that start from a specifc position and end in another specifc position in a string ?

Question

0.00/5 (No votes)

See more:

Hi all,
I have a string like this.
"This is a sample string with 215[145] - Microsoft Word"
And sometimes, there is possibility to have a string like this.
"This is a sample string with 85 - Microsoft Word"

In both cases, i want to extract the numbers. To be precise , i want "215" from first string and "85" from second string.
So i planned to use regex. This is my pseudo regex -
"Left side of the string must be a space, Then only catch numbers atleast one digit to maximum 3 digts, Then end position must be a space or a "[" sign.
How to tell regex to get my string ?

What I have tried:

VB

"\s[0-9]{1,3}[^[\s]]"

Posted 24-Jan-17 0:46am

Vinod Kc

Updated 24-Jan-17 1:21am

Add a Solution

Comments

Richard MacCutchan 24-Jan-17 6:48am

So what is the problem; does it work or not?

Vinod Kc 24-Jan-17 7:11am

Hi, Thanks for the reply. But it is catching a space in the beginning of the string. How to avoid it ?
I mean, this is the result now - " 85" and " 215"

Vinod Kc 24-Jan-17 7:00am

I got this from RegexBuddy.
"\s\d+([^\[\s])"

2 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)

OriginalGriff · Answer 1 · 2017-01-24T00:59:00

Solution 1

Try:

(?<=^[^\d]*)\d+(?=[^\d]*.*$)

It treats anything up to the first digit as an excluded prefix, matches all contiguous digits, then treats the rest of the line as an excluded suffix.

Posted 24-Jan-17 0:59am

OriginalGriff

Comments

Vinod Kc 24-Jan-17 7:15am

Thanks for the reply, But it is not working in RegexBuddy.

OriginalGriff 24-Jan-17 7:31am

It works for me when I test it in Expresso - so check your data and exactly how you are using it.

Patrice T · Answer 2 · 2017-01-24T01:21:00

Not a solution, just a few links ti help you to understand/build/debug RegEx.
Here is a link to RegEx documentation:
perlre - perldoc.perl.org[^]
Here is links to tools to help build RegEx and debug them:
.NET Regex Tester - Regex Storm[^]
Expresso Regular Expression Tool[^]
This one show you the RegEx as a nice graph which is really helpful to understand what is doing a RegEx:
Debuggex: Online visual regex tester. JavaScript, Python, and PCRE.[^]