script formula left / right

UserBird
Dataiker
script formula left / right
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
0 Kudos
1 Reply
cperdigou
Dataiker Alumni

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)


 

0 Kudos

Labels

?
Labels (3)
A banner prompting to get Dataiku