# Formula to decide if there is more than 1 email address in a text field

**URL:** <https://community.fibery.io/t/formula-to-decide-if-there-is-more-than-1-email-address-in-a-text-field/6268>\
**Category:** Get Help\
**Created:** [June 4, 2024, 6:50pm UTC](https://community.fibery.io/t/formula-to-decide-if-there-is-more-than-1-email-address-in-a-text-field/6268 "2024-06-04T18:50:29Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![YvetteLans](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/yvettelans/32/6101_2.png) [@YvetteLans](https://community.fibery.io/u/YvetteLans)\
**Post date:** [June 4, 2024, 6:50pm UTC](https://community.fibery.io/t/formula-to-decide-if-there-is-more-than-1-email-address-in-a-text-field/6268/1 "2024-06-04T18:50:29Z")

</div>

I’m trying to create a checkbox formula that’s true when there is more than 1 email address in a text field.

So my approach was to first replace everything else then the @ and then count the found @.

```auto
Find(ReplaceRegex([Email], "/[^@]/", ""), "@") > 1

```

But the ReplaceRegex formula (that ChatGPT generated) does not work.

Does somebody know the correct ReplaceRegex formula?

And if you have a better approach how to conclude if there is more than 1 email address, that’s also welcome 😄

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [June 4, 2024, 7:02pm UTC](https://community.fibery.io/t/formula-to-decide-if-there-is-more-than-1-email-address-in-a-text-field/6268/2 "2024-06-04T19:02:45Z")

</div>

You’re not counting the number of @s  
Using Find() will return the position of the first @ encountered.  
Try using Length() to find the length of the string after all the non-@ characters have been removed.

---

<div class="post-metadata">

**Author:** ![YvetteLans](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/yvettelans/32/6101_2.png) [@YvetteLans](https://community.fibery.io/u/YvetteLans)\
**Post date:** [June 4, 2024, 8:04pm UTC](https://community.fibery.io/t/formula-to-decide-if-there-is-more-than-1-email-address-in-a-text-field/6268/3 "2024-06-04T20:04:04Z")

</div>

> [@Chr1sG](#):
>
> Try using Length() to find the length of the string after all the non-@ characters have been removed.

Sounds good, thanks!

But how can I remove al non-@ characters? This ReplaceRegex doesn’t work in Fibery

```auto
ReplaceRegex([Email], "/[^@]/", "")

```

It seems that Fibery uses a different syntax than usual.

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [June 6, 2024, 8:00am UTC](https://community.fibery.io/t/formula-to-decide-if-there-is-more-than-1-email-address-in-a-text-field/6268/4 "2024-06-06T08:00:03Z")

</div>

It should just work with this

`ReplaceRegex([Email], "[^@]", "")`

🤞

---

<div class="post-metadata">

**Author:** ![YvetteLans](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/yvettelans/32/6101_2.png) [@YvetteLans](https://community.fibery.io/u/YvetteLans)\
**Post date:** [June 6, 2024, 10:47am UTC](https://community.fibery.io/t/formula-to-decide-if-there-is-more-than-1-email-address-in-a-text-field/6268/5 "2024-06-06T10:47:46Z")

</div>

> [@Chr1sG](#):
>
> ReplaceRegex([Email], “[^@]”, “”)

Awesome! Thanks again 🤩