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 |
