1 Message
Digest #4473
Message
Mon Jan 28, 2019 7:50 pm (PST) . Posted by:
"sri yanto" sri.yanto
thanks randy
its very helpfull...now i get it
thanks for being bear with all of us
On Monday, January 28, 2019, 4:27:31 PM GMT+7, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
I see four tables on the page. Try array-entering this over a range:
=RCHGetHTMLTable("https://www.reuters.com/finance/stocks/company-officers/UNTR.JK",">Since")
One quick way to check for tables:
- Open SMF-Quick-Webpage-Examination.xls
- Go to the "By HTML Tag" worksheet
- Enter the URL in cell C7, "table" in cell C8, and leave cell C9 empty. That should show you the source code for four tables.
- I see the ">Since" text in the first table, so then I go to the "table extract" worksheet
- Enter the URL in cell C6, ">Since" in cell C7, -1 in cell C8, 1 in cell C10, and leave C9 and C11 empty (these last four are the default values).
An easy way to use the "table extract" worksheet to see whether each table on the can be extracted is:
- Enter the URL in cell C6, leave C7, C9, and C11 empty, 1 in cell C8, "=C8" in cell C10. Basically saying extract the first table on the page.
- Now you can increment the value in cell C8 to see each following table.. 2, 3, 4, ...
On Mon, Jan 28, 2019 at 1:49 AM sri.yanto@... wrote:
pardon me ...i want to ask about reuters
its there any way to extract this part
https://www.reuters.com/finance/stocks/company-officers/UNTR.JK
particularly name and age part
i have been tried with :
=smfConvertData(smfStrExtr(RCHGetWebData("https://www.reuters.com/finance/stocks/company-officers/MAIN.JK",">Age<",250),">","<")) , its return "age", not the number
i tried to take a look IE, unfortunately i cant find any table
any suggestion?
#yiv4043776803 #yiv4043776803 -- #yiv4043776803ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4043776803 #yiv4043776803ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4043776803 #yiv4043776803ygrp-mkp #yiv4043776803hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv4043776803 #yiv4043776803ygrp-mkp #yiv4043776803ads {margin-bottom:10px;}#yiv4043776803 #yiv4043776803ygrp-mkp .yiv4043776803ad {padding:0 0;}#yiv4043776803 #yiv4043776803ygrp-mkp .yiv4043776803ad p {margin:0;}#yiv4043776803 #yiv4043776803ygrp-mkp .yiv4043776803ad a {color:#0000ff;text-decoration:none;}#yiv4043776803 #yiv4043776803ygrp-sponsor #yiv4043776803ygrp-lc {font-family:Arial;}#yiv4043776803 #yiv4043776803ygrp-sponsor #yiv4043776803ygrp-lc #yiv4043776803hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4043776803 #yiv4043776803ygrp-sponsor #yiv4043776803ygrp-lc .yiv4043776803ad {margin-bottom:10px;padding:0 0;}#yiv4043776803 #yiv4043776803actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4043776803 #yiv4043776803activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4043776803 #yiv4043776803activity span {font-weight:700;}#yiv4043776803 #yiv4043776803activity span:first-child {text-transform:uppercase;}#yiv4043776803 #yiv4043776803activity span a {color:#5085b6;text-decoration:none;}#yiv4043776803 #yiv4043776803activity span span {color:#ff7900;}#yiv4043776803 #yiv4043776803activity span .yiv4043776803underline {text-decoration:underline;}#yiv4043776803 .yiv4043776803attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv4043776803 .yiv4043776803attach div a {text-decoration:none;}#yiv4043776803 .yiv4043776803attach img {border:none;padding-right:5px;}#yiv4043776803 .yiv4043776803attach label {display:block;margin-bottom:5px;}#yiv4043776803 .yiv4043776803attach label a {text-decoration:none;}#yiv4043776803 blockquote {margin:0 0 0 4px;}#yiv4043776803 .yiv4043776803bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv4043776803 .yiv4043776803bold a {text-decoration:none;}#yiv4043776803 dd.yiv4043776803last p a {font-family:Verdana;font-weight:700;}#yiv4043776803 dd.yiv4043776803last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4043776803 dd.yiv4043776803last p span.yiv4043776803yshortcuts {margin-right:0;}#yiv4043776803 div.yiv4043776803attach-table div div a {text-decoration:none;}#yiv4043776803 div.yiv4043776803attach-table {width:400px;}#yiv4043776803 div.yiv4043776803file-title a, #yiv4043776803 div.yiv4043776803file-title a:active, #yiv4043776803 div.yiv4043776803file-title a:hover, #yiv4043776803 div.yiv4043776803file-title a:visited {text-decoration:none;}#yiv4043776803 div.yiv4043776803photo-title a, #yiv4043776803 div.yiv4043776803photo-title a:active, #yiv4043776803 div.yiv4043776803photo-title a:hover, #yiv4043776803 div.yiv4043776803photo-title a:visited {text-decoration:none;}#yiv4043776803 div#yiv4043776803ygrp-mlmsg #yiv4043776803ygrp-msg p a span.yiv4043776803yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4043776803 .yiv4043776803green {color:#628c2a;}#yiv4043776803 .yiv4043776803MsoNormal {margin:0 0 0 0;}#yiv4043776803 o {font-size:0;}#yiv4043776803 #yiv4043776803photos div {float:left;width:72px;}#yiv4043776803 #yiv4043776803photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv4043776803 #yiv4043776803photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4043776803 #yiv4043776803reco-category {font-size:77%;}#yiv4043776803 #yiv4043776803reco-desc {font-size:77%;}#yiv4043776803 .yiv4043776803replbq {margin:4px;}#yiv4043776803 #yiv4043776803ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv4043776803 #yiv4043776803ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4043776803 #yiv4043776803ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4043776803 #yiv4043776803ygrp-mlmsg select, #yiv4043776803 input, #yiv4043776803 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv4043776803 #yiv4043776803ygrp-mlmsg pre, #yiv4043776803 code {font:115% monospace;}#yiv4043776803 #yiv4043776803ygrp-mlmsg * {line-height:1.22em;}#yiv4043776803 #yiv4043776803ygrp-mlmsg #yiv4043776803logo {padding-bottom:10px;}#yiv4043776803 #yiv4043776803ygrp-msg p a {font-family:Verdana;}#yiv4043776803 #yiv4043776803ygrp-msg p#yiv4043776803attach-count span {color:#1E66AE;font-weight:700;}#yiv4043776803 #yiv4043776803ygrp-reco #yiv4043776803reco-head {color:#ff7900;font-weight:700;}#yiv4043776803 #yiv4043776803ygrp-reco {margin-bottom:20px;padding:0px;}#yiv4043776803 #yiv4043776803ygrp-sponsor #yiv4043776803ov li a {font-size:130%;text-decoration:none;}#yiv4043776803 #yiv4043776803ygrp-sponsor #yiv4043776803ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv4043776803 #yiv4043776803ygrp-sponsor #yiv4043776803ov ul {margin:0;padding:0 0 0 8px;}#yiv4043776803 #yiv4043776803ygrp-text {font-family:Georgia;}#yiv4043776803 #yiv4043776803ygrp-text p {margin:0 0 1em 0;}#yiv4043776803 #yiv4043776803ygrp-text tt {font-size:120%;}#yiv4043776803 #yiv4043776803ygrp-vital ul li:last-child {border-right:none !important;}#yiv4043776803
its very helpfull...now i get it
thanks for being bear with all of us
On Monday, January 28, 2019, 4:27:31 PM GMT+7, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
I see four tables on the page. Try array-entering this over a range:
=RCHGetHTMLTable("https://www.reuters.com/finance/stocks/company-officers/UNTR.JK",">Since")
One quick way to check for tables:
- Open SMF-Quick-Webpage-Examination.xls
- Go to the "By HTML Tag" worksheet
- Enter the URL in cell C7, "table" in cell C8, and leave cell C9 empty. That should show you the source code for four tables.
- I see the ">Since" text in the first table, so then I go to the "table extract" worksheet
- Enter the URL in cell C6, ">Since" in cell C7, -1 in cell C8, 1 in cell C10, and leave C9 and C11 empty (these last four are the default values).
An easy way to use the "table extract" worksheet to see whether each table on the can be extracted is:
- Enter the URL in cell C6, leave C7, C9, and C11 empty, 1 in cell C8, "=C8" in cell C10. Basically saying extract the first table on the page.
- Now you can increment the value in cell C8 to see each following table.. 2, 3, 4, ...
On Mon, Jan 28, 2019 at 1:49 AM sri.yanto@... wrote:
pardon me ...i want to ask about reuters
its there any way to extract this part
https://www.reuters.com/finance/stocks/company-officers/UNTR.JK
particularly name and age part
i have been tried with :
=smfConvertData(smfStrExtr(RCHGetWebData("https://www.reuters.com/finance/stocks/company-officers/MAIN.JK","
i tried to take a look IE, unfortunately i cant find any table
any suggestion?
#yiv4043776803 #yiv4043776803 -- #yiv4043776803ygrp-
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar