Join us on July 16th as we explore real-world Reinforcement Learning Learn more

script formula left / right

Dataiker
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
Dataiker
Dataiker

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 (3)