title: Google Sheets - Using regex to pull all data from a multi-line json file
body: <p>I have to extract data from bulk json files. The json files come in 2 different formats, either 1 block of continuous text, or a list of text of 20-30 lines.</p>
  <p>I'm using the following code:</p>
  <p><code>=IMPORTREGEX(E3,&quot;(.*')&quot;)</code></p>
  <p>(note that I have a script running which supports this formula)</p>
  <p>This works completely fine for the first format of json files, the 1 continuous block. But for the json files which are in list format, it only returns the first line.</p>
  <p>How can I make it return all the data from the entire list? (Ideally in a single cell, as if it was 1 continuous block of data, same as the other json format).</p>
  <p>Thanks!</p>