• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Find email and external links

good morning.

I would need some help. I'll explain the situation ...

In the column “a” there are links to different sites (i have indicated someone). Is able to extract in the column "b" all the emails of the corresponding link in column "a" and in column "c" the external links of the corresponding link in column "a"?


After extracting emails I should distinguish emails with the same path from those that have different paths.

Then referring to emails with the same path I have to locate the email that before the "@" spiral, contain a word (I will point at the top of the column - in the file find the rector). In addition to the rector word in the next columns, there may be other words to identify over time.

Thank you

https://www.dropbox.com/s/b6xg1ger71ri6o4/find email and external links.xlsx?dl=0
 
Good morning to allHo bed you can extract emailc on:
1) Pandas
2) xls modules - Openpyxl
Does anyone have any experience on this?
 
Back
Top