[libreoffice-users] extracting data from uri

Hi.  I am working on a calc sheet and need to insert data from an url:  

https://finance.google.com/finance/info?client=ig&q=NASDAQ%3aAAPL     


I  guess it generates a csv output  (in the browser it is like:  
// [ { "id": "22144" ,"t" : "AAPL" ,"e" : "NASDAQ" ,"l" : "99.92" ,"l_fix" : "99.92" ,"l_cur" : 
"99.92" ,"s": "0" ,"ltt":"12:13PM EDT" ,"lt" : "Jul 18, 12:13PM EDT" ,"lt_dts" : 
"2016-07-18T12:13:44Z" ,"c" : "+1.14" ,"c_fix" : "1.14" ,"cp" : "1.15" ,"cp_fix" : "1.15" ,"ccol" : 
"chg" ,"pcls_fix" : "98.78" } ]).   I would need to isolate the  number with 'l' label and insert 
it into a cell.

I also tried menu -> link external data -> url;  it opens the page, sees the table, but doesn't 
show it in the dialog box (with the checkbox 'update every x seconds'    ....   bug??).

Thanks if you can help.

Paolo

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted