Cant get headerlines to work
3 views (last 30 days)
Show older comments
Hi guys, I've recently bought Matlab and i dont know a great deal so bear with me. So i want to input data into matlab from
'http://jsoc.stanford.edu/SUM20/D358012442/S00000/Uy/1909:105.0_00.0W00.0N.Uy'
i use
urlread('http://jsoc.stanford.edu/SUM20/D358012442/S00000/Uy/1909:105.0_00.0W00.0N.Uy')
which gives me the data i need but i cant get it to ignore the first 7 lines of text.
I have been trying by textread('ans','headerlines', 7) which doesnt work.
If i select the data manually after putting in the urlread, and putting [..] around the data i want, it does give me what i want which comes up as '31x9 double' in workspace, instead of '1x2881 char'.
Can i get the data to be plotted in '31x9 double' directly from the website without me copy and pasting it, theres a lot of data so im looking for the shortest way. My explanation is terrible, i hope someone gets it, Any help is appreciated. Thanks in advance.
0 Comments
Accepted Answer
Star Strider
on 21 Oct 2014
Use urlwrite instead.
This works:
File = urlwrite('http://jsoc.stanford.edu/SUM20/D358012442/S00000/Uy/1909:105.0_00.0W00.0N.Uy','Stanford_Data.txt');
fidi = fopen(File);
D = textscan(fidi, repmat('%f',1,9), 'Delimiter','\n', 'HeaderLines',7);
Dd = cell2mat(D);
2 Comments
More Answers (1)
Geoff Hayes
on 21 Oct 2014
Cio - as you noted, the result of the urlread is a 1x2881 character array. To convert it to a matrix, you could just look for all occurrences within the string of the new line feed character whose ASCII decimal value is 10. You could then split all strings on this "delimiter" and get the 31x9 matrix as
resultStrAsArray = ...
urlread('http://jsoc.stanford.edu/SUM20/D358012442/S00000/Uy/1909:105.0_00.0W00.0N.Uy');
resultAsMatrix = char(strsplit(resultStrAsArray,char(10))');
% now remove the first seven rows
resultAsMatrix = resultAsMatrix(8:end,:);
Try the above and see what happens! Note that it may not work in all cases due to the assumption that the new line feed character (10) can be used to break the string array into multiple strings.
See Also
Categories
Find more on Get Started with MATLAB in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!