title: Extract text between quotation marks google sheets
body: <p>Looking to take a string along the lines of:</p>
  
  <p>"text": "fkjhsabhfkjhs7g8ydfgd.",
    "e": 1541699908958,
    "test": true</p>
  
  <p>and only extract the characters between the text field...so end up with only fkjhsabhfkjhs7g8ydfgd.</p>
  
  <p>The length of the text field can vary</p>
  
  <p>Tried this: =REGEXEXTRACT(C2,"""(.*?)""") with no luck</p>