This is probably pretty simple for most, but I’m just not great at regular expressions.
I have a set of strings with this type of format:
SYND_YAHOO_7BEST_RANKADDITIONS_268_2357425
So basically I want to search the string and extract the pattern _###_. Note that there can be 1 digit, or 2 or 3 or 4, etc. I know REGEXP_SUBSTR will do it for me, just not sure of the simple expression to use.
Thanks!
>Solution :
Assuming 268 is your desired match, a fairly simple pattern will work. Below returns the group of digits between underscores at the end of the string in the first capture group.
.*_(\d+)_.*$
https://regex101.com/r/gMCzdD/1
The main key here is that we start with .* which matches aggressively "as many times as possible" meaning that we’ll capture the last occurrence of digits between underscores, even if the same pattern occurs earlier in the string.