Regex Issues (v4.23)

[GlennMaples]

I'm on 4.23 -- waiting a bit to go to 5.X. But hoping someone would help me with a sanity check on my regex?

I have files where the series are displaying with extra brackets. Displayed in stock series column as:

[My Little Pony 01] [01]
[My Little Pony 02] [01]
[My Little Pony 03] [01]

My regex-->

Search field: Series
Destination field: Series_Index
Search For: (\d{2})
Replace: \1

This is about as simple it could be (infamous last words) and works in the regex101 online engine. But in 4.23 this is returning the entire Series (e.g.,
[My Little Pony 01] instead of the desired number: 02. I have never done regex in python and am hanging my head very low in my abject shame. thanks for your time. :-)

-glenn

[theducks]

you told it to search for a field with only 2 digits
You really want a field with somthin a space and 2 digits

.+?\s(\d{2})

[GlennMaples]

Thank you very much for your quick help.

Been a very long time since any regex -- and I was working with what the regular expressions 101 engine validated w\o thinking about what I was doing. :-(
Your code showed me to account for the string up to the two digits: .+?

works with or without space if I get that right.

[GlennMaples]

But, if I do as you suggested -- I don't end up with a trailing space. thanks again. :-)

[theducks]

Originally Posted by GlennMaples

T
Your code showed me to account for the string up to the two digits: .+?

works with or without space if I get that right.

\s a space
\s+ 1 or more of them
\s* optional or more

My .+? was to keep it from getting too Greedy
I wanted the pattern to always end in space 2digits

[GlennMaples]

One final note: I had some series with both a space before the number as well as no space:

[My Little Pony 02]
[My Little Pony03]

So I used conditional Regex like this to handle both cases.

Group 6 gives the extracted series name
Group 7 gives the extracted series_index

(\[(.+)?(\s\d{2}))(?(3)\[(.+)?(\d{2}))\]|\[(.+)?(\d{2})\]

This strikes me as being too verbose, but it seems to work.

[theducks]

you could have simply changed my original \s to \s* (assumes title has no digit pairs)