title: How to parse a single value out of a JSON or CSV string in Microsoft Excel? Or Google Sheets?
body: <p>I will have hundreds of cells which will use a webservice call to obtain stock data.  However, the data is only returned in JSON or CSV format.  Using one example, how can I obtain only the "uHigh" value from each dynamic JSON or CSV string, given the example below and knowing that the length of the number value could be different each time?</p>
  
  <pre><code>[{"date":"2020-01-22","uClose":1485.95,"uOpen":1491,"uHigh":1503.21,"uLow":1484.93,"uVolume":1610846,"close":1485.95,"open":1491,"high":1503.21,"low":1484.93,"volume":1610846,"change":1.55,"changePercent":0.1044,"label":"Jan 22","changeOverTime":0.001044}]
  </code></pre>
  
  <p>or I can parse CSV such as</p>
  
  <pre><code>"date,uClose,uOpen,uHigh,uLow,uVolume,close,open,high,low,volume,change,changePercent,label,changeOverTime,symbol
  2020-01-22,1485.95,1491,1503.21,1484.93,1610846,1485.95,1491,1503.21,1484.93,1610846,1.55,0.1044,Jan 22,0.001044,GOOG"
  </code></pre>
  
  <p>Excel offers a FILTERXML method but not one for JSON or CSV to my knowledge, so what can I put in my "=something-here" cell value to parse out just the uHigh value?</p>
  
  <p>I will use Google Sheets if that helps.</p>