How do I extract the string after 0: in big query sql-CodePudding

Home > Enterprise > How do I extract the string after 0: in big query sql

How do I extract the string after 0: in big query sql

Time：08-13

I want to extract extract "f9sdsdsd-1375-41f7-8c4c-ereb20ad3843c" from "0:f9696a03-1375-41f7-8c4c-34b20ad3843c".

I am currently using TRIM(REGEXP_EXTRACT("0:f9696a03-1375-41f7-8c4c-34b20ad3843c", r"0:[^:] )")) . However, I am not getting being able to extract it with the current syntax.

Can someone please help me here? Thanks.

CodePudding user response：

you are just simply missing ( - use below

TRIM(REGEXP_EXTRACT("0:f9696a03-1375-41f7-8c4c-34b20ad3843c", r"0:([^:] )"))

Page link：https//www.codepudding.com/Enterprise/509323.html

Prev:Change Colour Of Rollover Text On "Continue Shopping" WooCommerce Button

Next:Presto - How to convert a field with map<string,string> to rows

Tags：

sql

google-bigquery

Links：
CodePudding