Hi,
I am trying to extract the email address from webpage source code, that I previously passed into a string variable (webStr) :
I am only pasting part of the string wich is way too long :
inc38_columns1_col_bg_2" rel="inc38_container1"></div><div class="wp_column inc38_columns1_col_1"><div class="wp_bg inc38_columns1_col_bg_1" rel="inc38_container4"></div><div
class="wp_column inc38_columns1_col_0"><div class="wp_bg inc38_columns1_col_bg_0" rel="inc38_container3"></div><div id="inc38_container3" class="wp_col_content inc38_columns1_col_box_0"><div style="height:0px;width:0px;"> </div><div id="inc38_title2" class="inc38_title2_wp_outer"><h4 class="title">Contacte-Nos</h4><div class="clear_div" style="clear:both;height:0px;"> </div></div><div id="inc38_htmltext2" class="inc38_htmltext2_wp_outer"><span>Rua D. Francisco Manuel Melo 13,3º, 1070-085 Lisboa LISBOA, Portugal</span></div><div id="inc38_htmltext6" class="inc38_htmltext6_wp_outer"><a href="tel:213863076" aria-label="Link para App Mobile 213863076">Telefone: 213863076</a><div class="clear_div" style="clear:both;height:0px;"> </div></div><div id="inc38_htmltext7" class="inc38_htmltext7_wp_outer">E-mail: noemiacoelho-5087L@adv.oa.pt<div class="clear_div" style="clear:both;height:0px;"> </div></div><div class="clear_div" style="clear:both;height:0px;"> </div></div><div id="inc38_container4" class="wp_col_conten
t inc38_columns1_col_box_1"><div style="height:0px;width:0px;"> </div><div id="inc38_title1" class="inc38_title1_wp_outer"><h4 class="title">mapa</h4><div class="clear_div" style="clear:both;height:0px;"> </div></div><div id="inc38_map1" class="inc38_map1_wp_outer"><div id="inc38_mmap1_mapi" style="width: 100%; height: 100%; display:none;" aria-disabled="true"><span>Map goes here</span></div><div class="clear_div" style="clear:both;height:0px;"> </div></div><div class="clear_div" style="clear:both;height:0px;"> </div></div><div id="inc38_container1" class="wp_col_content inc38_columns1_col_box_2"><div style="height:0px;width:0px
I found the position of the character "@" with:
Pos_@ = InStr(1, WebStr, "@", vbTextCompare)
the following does not get part of the email, I wonder why? and how should I set the first character and lenght of the mid function ?
?mid(WebStr,First_@-25,50)
/ld+json">//<![CDATA[{"@context":"https://schema
I am trying to extract the email address from webpage source code, that I previously passed into a string variable (webStr) :
I am only pasting part of the string wich is way too long :
inc38_columns1_col_bg_2" rel="inc38_container1"></div><div class="wp_column inc38_columns1_col_1"><div class="wp_bg inc38_columns1_col_bg_1" rel="inc38_container4"></div><div
class="wp_column inc38_columns1_col_0"><div class="wp_bg inc38_columns1_col_bg_0" rel="inc38_container3"></div><div id="inc38_container3" class="wp_col_content inc38_columns1_col_box_0"><div style="height:0px;width:0px;"> </div><div id="inc38_title2" class="inc38_title2_wp_outer"><h4 class="title">Contacte-Nos</h4><div class="clear_div" style="clear:both;height:0px;"> </div></div><div id="inc38_htmltext2" class="inc38_htmltext2_wp_outer"><span>Rua D. Francisco Manuel Melo 13,3º, 1070-085 Lisboa LISBOA, Portugal</span></div><div id="inc38_htmltext6" class="inc38_htmltext6_wp_outer"><a href="tel:213863076" aria-label="Link para App Mobile 213863076">Telefone: 213863076</a><div class="clear_div" style="clear:both;height:0px;"> </div></div><div id="inc38_htmltext7" class="inc38_htmltext7_wp_outer">E-mail: noemiacoelho-5087L@adv.oa.pt<div class="clear_div" style="clear:both;height:0px;"> </div></div><div class="clear_div" style="clear:both;height:0px;"> </div></div><div id="inc38_container4" class="wp_col_conten
t inc38_columns1_col_box_1"><div style="height:0px;width:0px;"> </div><div id="inc38_title1" class="inc38_title1_wp_outer"><h4 class="title">mapa</h4><div class="clear_div" style="clear:both;height:0px;"> </div></div><div id="inc38_map1" class="inc38_map1_wp_outer"><div id="inc38_mmap1_mapi" style="width: 100%; height: 100%; display:none;" aria-disabled="true"><span>Map goes here</span></div><div class="clear_div" style="clear:both;height:0px;"> </div></div><div class="clear_div" style="clear:both;height:0px;"> </div></div><div id="inc38_container1" class="wp_col_content inc38_columns1_col_box_2"><div style="height:0px;width:0px
I found the position of the character "@" with:
Pos_@ = InStr(1, WebStr, "@", vbTextCompare)
the following does not get part of the email, I wonder why? and how should I set the first character and lenght of the mid function ?
?mid(WebStr,First_@-25,50)
/ld+json">//<![CDATA[{"@context":"https://schema