Use google sheets to grab some values

Viewed 22
1 Answers

try:

=REGEXEXTRACT(QUERY(FLATTEN(IMPORTDATA(A25)); 
 "where Col1 contains 'averageHashrate'"); "\d+(?:.\d+)?")

enter image description here

Related