urlread retrieves data but webread retrieves error

I'd like to retrieve data from a .csv generated by a website. urlread works, but is not recommended. webread returns a http error message. Anyone know what feature of webread causes different behavior than urlread? Alternatively, is there a script to just download the file (e.g. web.m but without the interactive browser)?
>> urlread('https://ssd.jpl.nasa.gov/sbdb_query.cgi?com_orbit_class=JFC;table_format=CSV;c_fields=AbAc;&query=1')
ans =
'spkid,full_name
1000099," 8P/Tuttle"
1000061," 96P/Machholz 1"
1000047," 126P/IRAS"
1000154," 262P/McNaught-Russell"
1003435," 333P/LINEAR"
1002585," 342P/SOHO"
1001439," P/1999 J6 (SOHO)"
1001843," C/2002 R5 (SOHO)"
1001852," P/2002 S7 (SOHO)"
1002413," P/2006 R1 (Siding Spring)"
1003317," P/2008 Y12 (SOHO)"
1003064," P/2010 D2 (WISE)"
1003231," P/2013 AL76 (Catalina)"
1003377," C/2015 D1 (SOHO)"
'
>> webread('https://ssd.jpl.nasa.gov/sbdb_query.cgi?com_orbit_class=JFC;table_format=CSV;c_fields=AbAc;&query=1')
ans =
<!DOCTYPE html
PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="en-US" xml:lang="en-US">
<head>
<title>ERROR</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
</head>
<body bgcolor="#FFFFFF" link="#FF0000" vlink="#0000FF">
<h2>Error Condition</h2>
</body>
</html>

 Respuesta aceptada

Damon Landau
Damon Landau el 25 de Mayo de 2018

0 votos

webread apparently doesn't like the semicolon delimiter between fields. I changed the semicolons to ampersands and it works.

2 comentarios

I have the same issue.
How is this an "Accepted Answer"? If I understand the fix is to manully edit the file to change the delimiters by hand?
Can webread delimiter be user settable? If not will urlread stay put until it does?
url = 'https://ssd.jpl.nasa.gov/sbdb_query.cgi?com_orbit_class=JFC;table_format=CSV;c_fields=AbAc;&query=1'
url = 'https://ssd.jpl.nasa.gov/sbdb_query.cgi?com_orbit_class=JFC;table_format=CSV;c_fields=AbAc;&query=1'
url_amp = regexprep(url, ';', '&')
url_amp = 'https://ssd.jpl.nasa.gov/sbdb_query.cgi?com_orbit_class=JFC&table_format=CSV&c_fields=AbAc&&query=1'
char(webread(url_amp).')
ans =
'spkid,full_name 1000099," 8P/Tuttle" 1000061," 96P/Machholz 1" 1000047," 126P/IRAS" 1000154," 262P/McNaught-Russell" 1003435," 333P/LINEAR" 1001542," 342P/SOHO" 1002413," 389P/Siding Spring" 1000981," C/1914 S1 (Campbell)" 1001439," P/1999 J6 (SOHO)" 1001843," C/2002 R5 (SOHO)" 1001852," P/2002 S7 (SOHO)" 1003317," P/2008 Y12 (SOHO)" 1003064," P/2010 D2 (WISE)" 1003231," P/2013 AL76 (Catalina)" 1003377," C/2015 D1 (SOHO)" 1003593," P/2017 TW13 (Lemmon)" '

Iniciar sesión para comentar.

Más respuestas (0)

Categorías

Más información sobre Downloads en Centro de ayuda y File Exchange.

Productos

Versión

R2017b

Preguntada:

el 22 de Mayo de 2018

Comentada:

el 13 de Mayo de 2021

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by