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

    I have the email [email protected]
    I know that domaine is [email protected]

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
asked by anonymous

1 Answer

0 votes

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)

 

answered by
595 questions
605 answers
440 comments
327 users