Hello,
I have a field in a table which has these types of emails in it.
tariq.jamal@gmail.com |
tariq.jamal+45@gmail.com |
johnmackenzie@gmail.coom |
I want to extract the first part only without + sign and domain
Expected Result (for above three records)
tariq.jamal
tariq.jamal
johnmackenzie
How can I do this in Alteryx Designer?
Solved! Go to Solution.
Hi @tjamal1
Here is how you can do it.
Workflow:
In ([\u\.]+).*@.* the ([\u\.]+) extracts string with letters and dot. \u stands for letters and \. stands for dot.
Hope this helps : )
Hi @tjamal1
Here is are some resources to learn more about Regex
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-RegEx/ta-p/37689
https://community.alteryx.com/t5/Interactive-Lessons/Replacing-Data-with-RegEx/ta-p/441426
Hope this helps : )
Happy to help : ) @tjamal1
Cheers and have a nice day!