Clear Filters
Clear Filters

Please help me...Extract data from url and wlswrite

1 view (last 30 days)
Jeong_evolution
Jeong_evolution on 30 Oct 2016
Commented: Jeong_evolution on 30 Oct 2016
url is
--------------------------------------------------------
<body
<data seq="0"
<hour3</hour
<day1</day
<temp8.0</temp
<tmx11.9</tmx
<tmn5.8</tmn
<sky3</sky
<pty0</pty
<wfKor구름 많음</wfKor
<wfEnMostly Cloudy</wfEn
<pop20</pop
<r120.0</r12
<s120.0</s12
<ws2.9000000000000004</ws
<wd7</wd
<wdKor북서</wdKor
<wdEnNW</wdEn
<reh57</reh
<r060.0</r06
<s060.0</s06
</data
<data seq="1"
<hour6</hour
<day1</day
<temp6.9</temp
<tmx11.9</tmx
<tmn5.8</tmn
<sky3</sky
<pty0</pty
<wfKor구름 많음</wfKor
<wfEnMostly Cloudy</wfEn
<pop20</pop
<r120.0</r12
<s120.0</s12
<ws2.8000000000000003</ws
<wd7</wd
<wdKor북서</wdKor
<wdEnNW</wdEn
<reh53</reh
<r060.0</r06
<s060.0</s06
--------------------------------------------------------
In url, I want to extract temp data (8.0 ,6.9)
and I wnat to export data (8.0 , 6.9) into excel.
Please help me!!

Sign in to answer this question.

Accepted Answer

Walter Roberson
Walter Roberson on 30 Oct 2016
Per already answered you about this in http://www.mathworks.com/matlabcentral/answers/309736-extract-numbers-from-mixed-string#answer_241254 . You use urlread to grab the string, and then you use the regexp that Per showed.

More Answers (0)

Categories

Find more on Spreadsheets in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!