# Separate text

**URL:** <https://community.glideapps.com/t/separate-text/74350>\
**Category:** Ask for Help\
**Created:** [June 24, 2024, 6:28pm UTC](https://community.glideapps.com/t/separate-text/74350 "2024-06-24T18:28:08Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![FelipeMilian](https://avatars.discourse-cdn.com/v4/letter/f/4af34b/32.png) [@FelipeMilian](https://community.glideapps.com/u/FelipeMilian)\
**Post date:** [June 24, 2024, 6:28pm UTC](https://community.glideapps.com/t/separate-text/74350/1 "2024-06-24T18:28:08Z")

</div>

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](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/1/a12df0ce1f42df0fcc2e33b6867f9b4827858fc2.png)

---

<div class="post-metadata">

**Author:** ![Hassan\_Nadeem](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hassan_nadeem/32/72956_2.png) [@Hassan\_Nadeem](https://community.glideapps.com/u/Hassan_Nadeem)\
**Post date:** [June 24, 2024, 6:59pm UTC](https://community.glideapps.com/t/separate-text/74350/2 "2024-06-24T18:59:45Z")

</div>

Use split text column and separate it using @ symbol.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [June 24, 2024, 7:02pm UTC](https://community.glideapps.com/t/separate-text/74350/3 "2024-06-24T19:02:41Z")

</div>

One way is with the [Extract Matching Text](https://www.glideapps.com/plugins/regex) column, using the following pattern:

```auto
^.*@(.*)$

```

 ![CleanShot 2024-06-25 at 03.02.21@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/0/6072adeaf0de83f8bb5f869356ae3068e9bdbff5.png)

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [July 1, 2024, 7:03pm UTC](https://community.glideapps.com/t/separate-text/74350/4 "2024-07-01T19:03:22Z")

</div>

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