带有双引号的字符串的REGEXEXTRACT数值

Question

我在google工作表单元格B1中有这个字符串：

{
  "schedules":[],
  "name": "10000 Stitches",
  "report": { 
    "printtitle": false, 
    "margin":"normal", "notes":false,
    "format":"pdf",
    "horizontal_alignment":"CENTER",
    "vertical_alignment":"TOP",
    "scale":"2",
    "filesettings":"individual",
    "pagenum":false,
    "sheetnames":false,
    "fzc":false,
    "layout":"landscape",
    "sheets": [
      {
        "sheetid":"287088559",
        "active":true,
        "filename":"",
        "cellrange":null
      }
    ],
    "size":"letter",
    "globalfilename":"",
    "gridlines":false,
    "fzr":false
  },
  "active":false,
  "id":3,
  "email": { 
    "body":"<p>attached</p>",
    "text":"",
    "subject": "{%'10000 Stitches'!B1%} payout report for {%'10000 Stitches'!B2%}",
    "to":"{%'10000 Stitches'!B6%}",
    "cc":"",
    "bcc":"",
    "fromname":"EPM Operations",
    "savetodrive":true,
    "drivefolderid":"129szEEvSqGa5D8fi6BVyMEp0bvCmYvTk",
    "bodytype":"html"
  }
}

我试着从."id":3,

我尝试过这个正则表达式(除其他外)

=REGEXEXTRACT(B1,"id"":(.*)")`

但请继续找出错误：

Function REGEXEXTRACT parameter 2 value "id":(.*)" does not match text of Function REGEXEXTRACT parameter 1 value "".

我不确定我对数字数据的双引号、冒号、逗号或通配符语法的处理是否错误。我研究过那么多堆叠溢出的线程，但我正在旋转我的轮子。任何帮助都将不胜感激。谢谢。

Answer 1

尝试以下几点

=REGEXEXTRACT(B1,"""id"":(\d)")*1

避免双引号"的方法是添加额外的双引号。

​

​