Select text in regex between 2 strings

Question

I have the following line :

3EAM7A 1 3 EI AMANDINE MRV SHP 70 W 0 SH3-A1 1 SHP 70W OVOIDE AI E27 SON PIA PLUS

I'd like to get the string : EI AMANDINE MRV SHP 70 W. So I decided to select the strings between 1 (can also be 2, 3 or 99) and 0 (can also be 1, 2, 3, 4 or 5).
I tried :

(0|1|2|3|99)(.*)(0|1|2|3|4|5)

But I have this result :

EAM7A 1 3 EI AMANDINE MRV SHP 70 W 0 SH3-A1 1 SHP 70W OVOIDE AI E

that is not what I want to obtain.

Do you have an idea in regex to make that selection work ?
Thanks !

Thank you very much to both of you for the answers ! It helps me a lot and you learned me different tricks to do so. Thanks again ! — Julien
– Julien, Commented Aug 13, 2015 at 14:16

d0nut · Accepted Answer · 2015-08-13 14:15:12Z

2

You were pretty close! Try this:

\b(?:0|1|2|3|99) ([^0|1|2|3|99].*?) (?:0|1|2|3|4|5)\b

Regex101

edited Aug 13, 2015 at 14:15

answered Aug 13, 2015 at 14:01

d0nut

2,8361 gold badge20 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

buckley · Accepted Answer · 2015-08-13 14:11:22Z

2

I think that you want to match "word" 4 to 9?

Your desired match will be in group 1

^(\S+\s){3}((\S+\s){6})

Enable the multiline option if you have a whole file of subject strings.

answered Aug 13, 2015 at 14:11

buckley

14.2k3 gold badges58 silver badges63 bronze badges

Comments

m.cekiera · Accepted Answer · 2015-08-13 14:07:16Z

1

You can try with:

\s(?:[0-3]|99)\s([A-Z].*?)\b(?:[0-5])\b

DEMO

and get string by group $1. Or if your language support look around, try:

(?<=\s[0-3]\s|99)[A-Z].+?(?=\s[0-5]\s)

DEMO

to get match directly.

answered Aug 13, 2015 at 14:07

m.cekiera

5,3935 gold badges24 silver badges35 bronze badges

Comments

Wiktor Stribiżew · Accepted Answer · 2015-08-13 14:32:15Z

1

Another solution that is based on matching all initial space + digit sequences:

\b(?:(?:[0-3]|99)\b\s*)+(.*?)\s*\b(?:[0-5])\b

See demo

The result is in Group 1. With \b(?:(?:[0-3]|99)\b\s*)+ the rightmost number from the allowed leading set is picked.

edited Aug 13, 2015 at 14:32

answered Aug 13, 2015 at 14:09

Wiktor Stribiżew

631k41 gold badges502 silver badges632 bronze badges

6 Comments

d0nut Over a year ago

Your regular expression incorrectly captures EI AMANDINE MRV SHP 70 W if the number before it is not in the set 0,1,2,3,99

Wiktor Stribiżew Over a year ago

@iismathwizard: I see, I added support for any space + number after the first number from the set.

d0nut Over a year ago

why? Op clearly stated the number will only be in the set [0-3|99]

Wiktor Stribiżew Over a year ago

I fixed it. And not [0-3|99], but ([0-3]|99).

Wiktor Stribiżew Over a year ago

@Whoever downvoted without a commet: you will have -1. That is why when downvoting, you need to declare what you did not like.

|

Kasravnd · Accepted Answer · 2015-08-13 14:10:19Z

0

You can use following regex :

(?:(?:[0-3]|99)\s)+(.*?)\s(?:[0-5])\s

See demo https://regex101.com/r/iX6oE1/6

Also note that for matching a range of number you can use a character class instead of multiple OR.

edited Aug 13, 2015 at 14:10

answered Aug 13, 2015 at 14:03

Kasravnd

108k19 gold badges167 silver badges195 bronze badges

3 Comments

d0nut Over a year ago

op doesn't want to capture all of that. EI AMANDINE MRV SHP 70 W

Kasravnd Over a year ago

@iismathwizard Yep, fixed!

d0nut Over a year ago

Actually, it's still wrong. it captures the 3 just before the string.

Collectives™ on Stack Overflow

Select text in regex between 2 strings

5 Answers 5

Comments

Comments

Comments

6 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

6 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related