regex extract all characters between a start and end string

Question

I have strings that looks like this.

setting-bs_b77f423715d2b991-node
setting-bs_b77f423715d2b991-eggs
setting-bs_b77f423715d2b991-cheese
setting-bs_b14835f519bf447d-ham

How do I extract just the middle element? e.g. bs_b14835f519bf447dit is always the same length and always has the same bs_ prefix.

I unfortunately cannot use a lookbehind for this problem, as suggested in this answer as the regex must run inside bigquery which does not support lookbehinds

Assuming you have no other 16-char alphanumeric words then `[a-z0-9]{16}` could work. https://regex101.com/r/6vhSH6/1 — MonkeyZeus, May 18 '22 at 13:52
@MonkeyZeus Thank you, that appeared to work correctly. If you answer I can mark as answer — Tom, May 18 '22 at 13:54

score 1 · Accepted Answer · answered May 18 '22 at 13:55

1

Assuming you have no other 16-char alphanumeric words then [a-z0-9]{16} could work.

https://regex101.com/r/6vhSH6/1

answered May 18 '22 at 13:55

MonkeyZeus

20,375
4
36
77

regex extract all characters between a start and end string

1 Answers1