Forum Discussion
Substring specific part of values
Hi,
I am looking for a solution to keep only the names. Examples:
John Doe <[email protected]> --> John Doe
Elizabeth Taylor <[email protected]> --> Elizabeth Taylor
Thank you!
HI Anonymous ,
This is a similar solution
https://community.powerbi.com/t5/Desktop/Strip-out-domain-name-from-an-email-address/td-p/72883
https://community.powerbi.com/t5/Power-Query/Strip-first-and-last-name-from-email-address/m-p/730378
In DAX You can try
Column = LEFT(Table[Email],FIND("@",Table[Email])-1)
Regards,
Harsh Nathani
5 Replies
HI Anonymous ,
This is a similar solution
https://community.powerbi.com/t5/Desktop/Strip-out-domain-name-from-an-email-address/td-p/72883
https://community.powerbi.com/t5/Power-Query/Strip-first-and-last-name-from-email-address/m-p/730378
In DAX You can try
Column = LEFT(Table[Email],FIND("@",Table[Email])-1)
Regards,
Harsh Nathani
Hi Anonymous ,
Try something as follows in Query Editor:
Data is as follows suppose,
Then click on your column --> TRANSFORM --> EXTRACT,
A window appears, add your delimiter value as shown,
You get the required output,
Thanks,
Pragati
Anonymous , You can use power bi text operation
https://docs.microsoft.com/en-us/powerquery-m/text-functions
Hi Anonymous ,
If all of the suggestions worked at your end, please mark all of them as the solution to this thread. Just helps others with different ways of achieving results.
Thanks,
Pragati
