# Negative Regex to extract rows with/without email address?

**URL:** <https://community.parabola.io/t/negative-regex-to-extract-rows-with-without-email-address/1102>\
**Category:** Ask a question\
**Created:** [September 24, 2020, 4:41pm UTC](https://community.parabola.io/t/negative-regex-to-extract-rows-with-without-email-address/1102 "2020-09-24T16:41:04Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Tony\_Standing](https://avatars.discourse-cdn.com/v4/letter/t/df788c/32.png) [@Tony\_Standing](https://community.parabola.io/u/Tony_Standing)\
**Post date:** [September 24, 2020, 4:41pm UTC](https://community.parabola.io/t/negative-regex-to-extract-rows-with-without-email-address/1102/1 "2020-09-24T16:41:04Z")

</div>

Hi  
I have some date in a column. Some of the data contains email addresses and some just text but this may contain an @ symbol.  
I only want to keep the rows where there is an email address. I have tried using the Regex, but in essence I need it to be a negative regex, so the rows with “call me @ 12” are removed.

At present I use a simple filter, must contain @ but this does not work for the “call me @ 12”. Does anyone know how I can keep just the rows with a valid email address?

---

<div class="post-metadata">

**Author:** ![brian](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/brian/32/11_2.png) [@brian](https://community.parabola.io/u/brian)\
**Post date:** [September 24, 2020, 9:41pm UTC](https://community.parabola.io/t/negative-regex-to-extract-rows-with-without-email-address/1102/2 "2020-09-24T21:41:44Z")

</div>

Try the Regex Step, and use this pattern I found in the community section of [regexr.com](http://regexr.com)

```auto
[a-z0-9!#$%&'*+/=?^_`{|}~-]+(?:\.[a-z0-9!#$%&'*+/=?^_`{|}~-]+)*@(?:[a-z0-9](?:[a-z0-9-]*[a-z0-9])?\.)+[a-z0-9](?:[a-z0-9-]*[a-z0-9])?

```

If that is missing a character due to this post format, just grab the pattern here: [regexr.com/2rhq7](http://regexr.com/2rhq7)

Starting with this data:

 ![image](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/1X/a16d1c232ca7114bd41bbfeb795192d2571f585b.png)

I get this result:

 ![image](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/1X/5208b9380a001245e70a6da66ba15ed382807ead.png)

Then you can filter by that new column to only keep rows with an email detected in it.