Hi here,
I have strings with variable length and I need to extract a certain pattern into a custom column.
Sample string (I need the digits after the last underscore):
AV11_V242_240214_173019_105335
Output would be: 105335
A regex that works at regex101.com:
(?:([a-zA-Z0-9]{4}))(?:([a-zA-Z0-9]{3,4}))(?:([0-9]{6}))(?:([0-9]{6}))(.*)
But this does not work at Metabase on a custom field.
I've also tried regex lookahead and lookbehind but those dont work either.
Any ideas?
Thanks