Separating an email from the free text field

Linda — Mon, 01 Aug 2022 09:00:58 GMT

I have a free text field which contains both telephone & email ('ContactData'). I would like to create a field in the script ('Email') which contains only the email. The field can contain all the possible combinations you can imagine. Below just few examples.

How would you solve this?

Example

ContactData (Field in the database)	Email (Wanted result)
012 345 6789 / example@example.com	example@example.com
0123456789. example@example.com	example@example.com
0123456789, example.123@example.com	example.123@example.com
0123456789 example@example.com	example@example.com
tel:0123456789 e-mail;example@example.com	example@example.com
example@example.com 0123456789	example@example.com
0123456789 and example@example.com	example@example.com
0123456789<example@example.com	example@example.com
0123456789/example@example.com	example@example.com
0441234567... example.p@example.com	example.p@example.com
+35823456789example@example.com	example@example.com
0123456789 example@example.com 2.tel.phone 0123456789	example@example.com

topic Separating an email from the free text field in App Development

Separating an email from the free text field