'regex extract all characters between a start and end string
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
Solution 1:[1]
Assuming you have no other 16-char alphanumeric words then [a-z0-9]{16} could work.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | MonkeyZeus |