How to extract and count email address?

[stick-o]

Hello. How to extract and count personal email address? Say the destination email field (d-email) contains email as below:

abc.work-email.com
cef.work-email.com
a.gmail.com
b.hotmail.com

I want to see how many email was sent to Gmail/Hotmail or any personal account.

[yuanliu]

How about excluding work-email.com?

| where NOT match('d-email', "\.work-email\.com$")
| stats count

[stik-0]

there will be thousands of business email domains. Will be difficult this way. 

[stik-0]

I managed to get this working. 

Solved: Regex to extract email domain name - Splunk Community