script formula left / right
Options
UserBird
Dataiker, Alpha Tester Posts: 535 Dataiker
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
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
Tagged:
Answers
-
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)
