How to screen double quotes in Google Docs re2 expressions?

Question

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

Answer 1

You need to escape a doublequote " with another doublequote like this "".

Try using this,

=REGEXEXTRACT(A1,"""(.*)""")

Verified and this works well.

Answer 2

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