Harvest data from a website

Question

Khalala Mamouri 2020-9-16

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/594538-harvest-data-from-a-website

回答： Xavier 2020-9-16

Hi ,

I am looking for a way to retreive data from a web site to built a database for my app. What i want to do is to get for exemple : Thermal Resistance @ Forced Air Flow

from the this website :

https://www.digikey.com/products/en/fans-thermal-management/thermal-heat-sinks/219

I found this forum https://www.mathworks.com/matlabcentral/answers/400522-retrieving-data-from-a-web-page but i dont know why it does not work for me. maybe if someone helps me with an exemple to extract Thermal Resistance @ Forced Air Flow could help me

thank you

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Xavier 2020-9-16

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/594538-harvest-data-from-a-website#answer_495370

在 MATLAB Online 中打开

There are admittedly more glamourous ways of doing this, but this works

% Get the html for the webpage
html = webread("https://www.digikey.com/products/en/fans-thermal-management/thermal-heat-sinks/219");
% find the start and end of the data and remove the rest
iStart = strfind(html, "Thermal Resistance @ Forced Air Flow");
iStart = iStart(1);
iEnd = strfind(html, "Thermal Resistance @ Natural");
iEnd = iEnd(1);
html = html(iStart:iEnd);
% get the indexes of the start and finish of the data points
iStart = strfind(html, "<option value") +23;
iEnd = strfind(html, "</option")-1;
% pre-allocate results
results = strings(numel(iStart), 1);
% write and clean up results
for i = 1:numel(results)
    
    results(i) = string(html(iStart(i):iEnd(i)));
    results(i) = strrep(results(i), " ", "");
    results(i) = strip(results(i));
    
end