Coming soon: We’re working on a brand new, revamped Community experience. Want to receive updates? Sign up now!
As a first step you will be interested by the "split email" processor (https://doc.dataiku.com/dss/latest/preparation/processors/email-split.html)
In your specific case, if the dot is present you can use a "split column" (https://doc.dataiku.com/dss/latest/preparation/processors/split.html) using a dot as delimiter.
Otherwise, you can use a formula with