Wiktor Stribiżew
2020-12-01 04:51:29
You can use
REGEXP_REPLACE(col, r".*ga/([^/$]*)\${4}.*", r"\1")
See the regex demo.
The identical, but a bit simplified since .* will become redundant, pattern can be used in REGEGEXP_EXTRACT:
REGEXP_EXTRACT(col, r"ga/([^/$]*)\${4}")
Pattern details:
.*- any zero or more chars other than line break chars, as many as possiblega/-gaand a slash([^/$]*)- Group 1: any zero or more chars other than/and$\${4}- four$symbols.*- any zero or more chars other than line break chars, as many as possible.
The replacement is the Group 1 backreference, \1, that replaces the whole match with the contents of the group.
热门帖子
热门github
6
And for the second string
REGEXP_REPLACE(_FILE_NAME, r".*ga/([^/$]*)\${4}(.*)\.csv", r"\2")THANKS