script formula left / right

UserBird

Dear all, could you please hellp me with a script, how can I devide the information according the rule:

I have the email asolomatina@valeo.fr
I know that domaine is n.surename@

How can i Divede to different colomns the domaine from email to have in the first colomn "a" and at the second one "solomatina"?

Thank youin advance.



Anastasiia

cperdigou

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

substring(email, 0,1)