Separate text

I have this Email column, I need to separate the domain from the first text, that is, before the @.

I’m checking that the email entered in this column can only be saved when it is the defined domain.

how do I do this?

Thank you very much.

image

Use split text column and separate it using @ symbol.

1 Like

One way is with the Extract Matching Text column, using the following pattern:

^.*@(.*)$

3 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.