stefanoste78
Member
Good morning.
I found the shihin code at this link for email extraction and contact telephone numbers:
Could you help me find the right regex expression for both extrapolating landline and mobile phone numbers.
For this I have inserted all the fixed and mobile prefixes in the second sheet of the file that I have attached
Then it is possible to modify the shihin code so that the extraction can take place from a list of urls contained in the column a of the sheet and can provide for the possibility of extracting the email, landline and mobile phone taking into account that sometimes there may be multiple emails or fixed and mobile numbers (italian numbers)?
At this link (https://stackoverflow.com/questions/35794734/italian-phone-10-digit-number-regex-issue ) I found the ways in which a telephone number can appear.
1) whole without international prefix;
2) with international prefix (+39);
3) the variants between the two with space after the prefix or the international prefix or prefix in round brackets.
I don't know if there can be others.
Thank you
I found the shihin code at this link for email extraction and contact telephone numbers:
Unable to use regex within vba scraper in the right way
Hi there!! This is my first ever attempt to work with regex which is supposed to be applied on "responsetext" to find any phone number from a webpage. As I never used regex within vba, I'm not at all sure what I did in my below script is at all permissible cause I found it from a site and tried...
chandoo.org
Could you help me find the right regex expression for both extrapolating landline and mobile phone numbers.
For this I have inserted all the fixed and mobile prefixes in the second sheet of the file that I have attached
Then it is possible to modify the shihin code so that the extraction can take place from a list of urls contained in the column a of the sheet and can provide for the possibility of extracting the email, landline and mobile phone taking into account that sometimes there may be multiple emails or fixed and mobile numbers (italian numbers)?
At this link (https://stackoverflow.com/questions/35794734/italian-phone-10-digit-number-regex-issue ) I found the ways in which a telephone number can appear.
1) whole without international prefix;
2) with international prefix (+39);
3) the variants between the two with space after the prefix or the international prefix or prefix in round brackets.
I don't know if there can be others.
Thank you
Attachments
Last edited: