Extracting data from web pages

zakynthos · May 24, 2012

Hi,

How would I do the following?

Extract the following data from the example web page source code below into columns A, B, C etc on Sheet2, starting in A2,B2,C2?

example data

name ([FONT=&quot]Other AN Mr )[/FONT]
[FONT=&quot]job title ([/FONT]Sales Manager)
tel no ([FONT=&quot]0000[/FONT][FONT=&quot]321[/FONT][FONT=&quot]1234)[/FONT]

There are 2 additional items on the web page itself that I would like to extract but which are not contained in the page source code below - mobile tel no and email address - is there some way I can extract them (to D2 and E2 on sheet2) other than through the source code?

Many thanks!

[FONT=&quot]
[/FONT]
!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"</pre>
<input class="SYN_LNN" value="2" id="syn_ctrl2" type="label"> <input id="syn_ctrl2" class="SYN_BCH" value="-" role="button" type="label"> "http://www.AZ.org/TR/REC-html40/loose.dtd"></pre>
<input class="SYN_LNN" value="3" id="syn_ctrl3" type="label"> <input id="syn_ctrl3" class="SYN_BCH" value="-" role="button" type="label"> HTML></pre>
HEAD></pre>
<input class="SYN_LNN" value="6" id="syn_ctrl6" type="label"> <input id="syn_ctrl6" class="SYN_BCH" value="-" role="button" type="label"> TITLE>Search results/TITLE></pre>
<input class="SYN_LNN" value="7" id="syn_ctrl7" type="label"> <input id="syn_ctrl7" class="SYN_BCH" value="-" role="button" type="label"> META http-equiv="Pragma" content="no-cache">LINK REL=stylesheet TYPE="text/css" HREF="/styles/S1.css"></pre>
<input class="SYN_LNN" value="8" id="syn_ctrl8" type="label"> <input id="syn_ctrl8" class="SYN_BCH" value="-" role="button" type="label"> !--[if IE]>style type="text/css"></pre>
<input class="SYN_LNN" value="9" id="syn_ctrl9" type="label"> <input id="syn_ctrl9" class="SYN_BCH" value="-" role="button" type="label"> body { width: expression( ( document.documentElement.clientWidth - 20 ) + 'px' ); }</pre>
<input class="SYN_LNN" value="10" id="syn_ctrl10" type="label"> <input id="syn_ctrl10" class="SYN_BCH" value="-" role="button" type="label"> /style>![endif]--></pre>
<input class="SYN_LNN" value="11" id="syn_ctrl11" type="label"> <input id="syn_ctrl11" class="SYN_BCH" value="-" role="button" type="label"> STYLE TYPE="text/css"> </pre>
<input class="SYN_LNN" value="12" id="syn_ctrl12" type="label"> <input id="syn_ctrl12" class="SYN_BCH" value="-" role="button" type="label"> TABLE.ResultsList TD {padding-top: 0.5em;}</pre>
<input class="SYN_LNN" value="13" id="syn_ctrl13" type="label"> <input id="syn_ctrl13" class="SYN_BCH" value="-" role="button" type="label"> /STYLE></pre>
<input class="SYN_LNN" value="14" id="syn_ctrl14" type="label"> <input id="syn_ctrl14" class="SYN_BCH" value="-" role="button" type="label"> /HEAD></pre>
<input class="SYN_LNN" value="15" id="syn_ctrl15" type="label"> <input id="syn_ctrl15" class="SYN_BCH" value="-" role="button" type="label"> BODY ******="if (parent.frames[1].location.pathname == '/blank.html') {parent.frames[1].location = '/pls/ids/person?id=123456'};"></pre>
<input class="SYN_LNN" value="16" id="syn_ctrl16" type="label"> <input id="syn_ctrl16" class="SYN_BCH" value="-" role="button" type="label"> P CLASS="PageTitle" STYLE="margin-top: 0; margin-bottom: 0;">Search results</pre>
<input class="SYN_LNN" value="17" id="syn_ctrl17" type="label"> <input id="syn_ctrl17" class="SYN_BCH" value="-" role="button" type="label"> SPAN CLASS="PageSubTitle">1 person found/SPAN></pre>
<input class="SYN_LNN" value="18" id="syn_ctrl18" type="label"> <input id="syn_ctrl18" class="SYN_BCH" value="-" role="button" type="label"> /P></pre>
<input class="SYN_LNN" value="19" id="syn_ctrl19" type="label"> <input id="syn_ctrl19" class="SYN_BCH" value="-" role="button" type="label"> TABLE CLASS="ResultsList"></pre>
<input class="SYN_LNN" value="20" id="syn_ctrl20" type="label"> <input id="syn_ctrl20" class="SYN_BCH" value="-" role="button" type="label"> TR>TD ALIGN=left VALIGN=top WIDTH="100%">1</pre>
<input class="SYN_LNN" value="21" id="syn_ctrl21" type="label"> <input id="syn_ctrl21" class="SYN_BCH" value="-" role="button" type="label"> B>A HREF="person?id=123456" TARGET="main_right">Other AN Mr (Arthur)/A>/B></pre>
<input class="SYN_LNN" value="22" id="syn_ctrl22" type="label"> <input id="syn_ctrl22" class="SYN_BCH" value="-" role="button" type="label"> (A HREF="http:// Wholesale.intra.abc.com/index.htm" TARGET=_top>AZ Wholesale/A>, A HREF="staff?id=234567" TARGET="main_right">MK43/A>)BR>A HREF="http://operation.intra.az.com/operation/index/organisation/azsecurity/security_policy/security_when_to_use_policies/old_security_policy_6_2_9_0_0.htm" TARGET="_blank" CLASS="empClassPlain">AZ Employee/A></pre>
<input class="SYN_LNN" value="23" id="syn_ctrl23" type="label"> <input id="syn_ctrl23" class="SYN_BCH" value="-" role="button" type="label"> </pre>
<input class="SYN_LNN" value="24" id="syn_ctrl24" type="label"> <input id="syn_ctrl24" class="SYN_BCH" value="-" role="button" type="label"> BR>Leasing Sales Manager</pre>
<input class="SYN_LNN" value="25" id="syn_ctrl25" type="label"> <input id="syn_ctrl25" class="SYN_BCH" value="-" role="button" type="label"> BR>Tel: 0000 321 1234</pre>
<input class="SYN_LNN" value="26" id="syn_ctrl26" type="label"> <input id="syn_ctrl26" class="SYN_BCH" value="-" role="button" type="label"> BR>A HREF="whereabouts.display_items?id=229545" TARGET="main_right">Whereabouts/A>, Today:BR>12:00 - 13:00 AZ Finance Meeting - My Meeting: BR>17:00 - 17:15 Send AM Financial Info</pre>
<input class="SYN_LNN" value="27" id="syn_ctrl27" type="label"> <input id="syn_ctrl27" class="SYN_BCH" value="-" role="button" type="label"> /TABLE></pre>
<input class="SYN_LNN" value="28" id="syn_ctrl28" type="label"> <input id="syn_ctrl28" class="SYN_BCH" value="-" role="button" type="label"> /SPAN>/BODY></pre>
<input class="SYN_LNN" value="29" id="syn_ctrl29" type="label"> <input id="syn_ctrl29" class="SYN_BCH" value="-" role="button" type="label"> /HTML></pre>

Extracting data from web pages

zakynthos

Board Regular

Excel Facts

Similar threads

Forum statistics

Share this page

Extracting data from web pages

zakynthos

Board Regular

Excel Facts

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock