Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: 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