Google BigQuery extract string from column with regexp_extract - string value

Question

I know there's similar question, but in my case the solution didn't work since there's no valid delimiter.

I have a string inside a column:

{"module-version": "2.0", "more-details-link": ""}, "has-cve": true, "issue-package": "VM-Essentials", "legacy-scan-status": "removed"}

I need the inside of issue-package. I tried: REGEXP_EXTRACT(details_issues.issue_raw,r'\"issue-package=(.+?)\,')

But i'm getting Null inside the column. Any suggestions?

Jeff Meatball Yang · Accepted Answer · 2021-02-10 11:10:35Z

1

If this is a JSON string, you should use JSON_* functions instead.

You can try something like:

JSON_EXTRACT(details_issues.issue_raw, '$.issue-package')

answered Feb 10, 2021 at 11:10

39.3k27 gold badges94 silver badges125 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1