Search code examples
regexgoogle-docsre2

How to screen double quotes in Google Docs re2 expressions?

I'm trying to screen double quotes in regular expression on Google Sheets and there's no luck. A1 cell text = some "name" My formula

=REGEXEXTRACT(A1;"\"(.*)\"")

But Google Docs thinks that i'm using quotes for open /close argument. Please help.

Library that GoogleDocs using for regular expressions is re2

Solution

  • =REGEXEXTRACT(A1; "[""]+(\w*)")