Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Linda
Contributor
Contributor

Separating an email from the free text field

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
Labels (1)
0 Replies