SQL Query to remove particular in Big query-CodePudding

Home > Software design > SQL Query to remove particular in Big query

SQL Query to remove particular in Big query

Time：09-28

I have columns like

I want only Hour Month GB/Month Gib/Hour

please help me right query in bigquery

CodePudding user response：

Try below regexp_replace(col, r'1 /?', '')

if applied to sample data in your question - output is