Extracting e-mail addresses from Sharepoint site/database

Question

I would like to extract e-mail addresses from a Sharepoint site/database. One list item in Sharepoint can contain several addresses inside a textbox, so I need some sort of regular expression or other trick to recognize what is an e-mail address and what is not.

So I'm not sure which approach is the best. SQL Queries and/or script?

Answer 1

Hi nctrnl,

You can write the custom code in C# that will traverse through each and every item of the list. If one item of the list contains more than one email address then there should be email separator character like semicolon or comma. You can break/split the string from that point and then check each token with regular expression to verify if it is a valid email address or not.

I hope this helps!