Extract name and organization from an e-mail address

I need help on how to generate an expression that will extract the name, organization/company and if possible the domain/Subdomain

I have a set of e-mails of commonly seperated by dots or formatted by uppercases - this should distinguish the first and last name, else the last name will return as null

For example the following email address (note: @ sign was replace with (at) because e-mail addresses are protected on this forum for spambots)

JOHN.DOE(at)QANTAS.AU
MichaelGreen(at)harvard.edu
jonathanreids(at)alitalia.it
kevinlee(at)gmail.com

should return

First Name Last Name Organization Other
John Doe Qantas Australia
Michael Green Harvard Education
jonathanreids NULL Alitalia Italy
kevinlee NULL GMAIL Commercial

Thank you for your question.

This can be easily done by using split transformation function.

See attached actual transformation