title: How to use regex correctly with this REGEXEXTRACT function?
body: <p>I'm dealing with a large spreadsheet of order data which uses a unique, sort of hashed string of syntax to represent order items and attributes.</p>
  
  <p>I currently have this data in Google Sheets and I'm hoping to be able to make use of the REGEXEXTRACT function (<a href="https://support.google.com/docs/answer/3098244" rel="nofollow noreferrer">https://support.google.com/docs/answer/3098244</a>) to retrieve the pieces of information I need from each row. </p>
  
  <p>Example of function: REGEXEXTRACT("Needle in a haystack", ".e{2}dle")</p>
  
  <p>Order data is huge and I believe I can use this regex function to isolate the piece of information I want.</p>
  
  <p>Examples of the portion of string snippets I need to work with. Keeping in mind the actual order string is much longer than this:</p>
  
  <ul>
  <li>"Location\";s:5:\"value\";s:7:\"Atlanta\"</li>
  <li>"Location\";s:2:\"value\";s:8:\"New York\"</li>
  <li>"Location\";s:5:\"value\";s:15:\"barrio de boedo\"</li>
  </ul>
  
  <p>So the common string in each row is Location, as value is used multiple times throughout each order.</p>
  
  <p>Let me see if I can articulate this correctly: <strong>How would I use regex to specify the value between the 4th and 5th double quotes occurring immediately after the string 'Location' so that in my examples above, the results would be Atlanta, New York, barrio de boedo?</strong></p>
  
  <p>For reference, the barrio de boedo example in its entirety:
  <em>\";s:7:\"product\";s:2:\"31\";s:8:\"form_key\";s:16:\"aasdf\";s:7:\"options\";a:2:{i:1;s:1:\"2\";i:2;s:15:\"barrio de boedo\";}s:15:\"super_attribute\";a:2:{i:92;s:1:\"4\";i:132;s:1:\"9\";}s:3:\"qty\";s:1:\"1\";}s:7:\"options\";a:2:{i:0;a:7:{s:5:\"label\";s:15:\"Language-Gender\";s:5:\"value\";s:8:\"spa-male\";s:11:\"print_value\";s:8:\"spa-male\";s:9:\"option_id\";s:1:\"1\";s:11:\"option_type\";s:9:\"drop_down\";s:12:\"option_value\";s:1:\"2\";s:11:\"custom_view\";b:0;}i:1;a:7:{s:5:\"label\";s:8:\"Location\";s:5:\"value\";s:15:\"barrio de boedo\";s:11:\"print_value\";s:15:\"barrio de boedo\";s:9:\"option_id\";s:1:\"2\";s:11:\"option_type\";s:5:\"field\";s:12:\"option_value\";s:15:\"barrio de boedo\";s:11:\"custom_view\";b:0;}}s:15:\"attributes_info\";a:2:{i:0;a:2:{s:5:\"label\";s:5:\"Color\";s:5:\"value\";s:4:\"Grey\";}i:1;a:2:{s:5:\"label\";s:4:\"Size\";s:5:\"value\";s:1:\"L\";}}s:11:\"simple_name\";s:14:\"T-Shirt-Grey-L\";s:10:\"simple_sku\";s:14:\"t-shirt-Grey-L\";s:20:\"product_calculations\";i:1;s:13:\"shipment_type\";i:0;}"</em></p>