Another regex question

[sdspioeg]

How can I I split a column that contains email addresses, followed by a '.' (period) followed by any combination of digits into two separate columns via regex?

So 

joe@whitehouse.gov.593 to

joe@whitehouse.gov

593

Sorry to ask but I've been breaking my head over this for the past two hours :(

[joelmiller66 · Accepted solution]

@sdspioeg Think this should do the trick

(.*\@.*)\.(\d+)

[sdspioeg]

Wow. THAT was fast... Thanks much Joel!