我不明白我的語法有什么問題。
詢問的相關部分:
COUNTIF(REGEXP_REPLACE(JSON_EXTRACT(view_context, '$. exit_event'), '', '') = 'TAP_RIGHT') AS is_view_ctx_tap_right, COUNTIF(REGEXP_REPLACE(JSON_EXTRACT(view_context, '/span>$. exit_event'), ''', '') = 'TAP_LEFT') AS is_view_ctx_tap_left
錯誤:
無法決議正則運算式:意外的)。) , '') = 'TAP_RIGHT') AS is_view_ctx_tap_right, COUNTIF(REGEXP_REPLACE(JSON_EXTRACT(view_context, '$.exit_event'),
uj5u.com熱心網友回復:
試試下面的方法吧
COUNTIF(REGEXP_REPLACE(JSON_EXTRACT(view_context, '$.exit_event'), "'", ') = 'TAP_RIGHT') AS is_view_ctx_tap_right,
COUNTIF(REGEXP_REPLACE(JSON_EXTRACT(view_context, '$.exit_event'), "' ", ') = 'TAP_LEFT') AS is_view_ctx_tap_left
注意提議的修復。""而不是""
轉載請註明出處,本文鏈接:https://www.uj5u.com/houduan/306839.html
標籤:
