Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Remove the unwanted name

Please help me to implement the below logic in Qlik Sense: I have the names as below: Abc.def@gmail.com A.de@ gmail.com Aaaaaaa.bbbbb@gmail.com... And so on.. I just want names as: Abc.def A.de Aaaaaaa.bbbbb Please help me Thanks Deepanshu

1 Solution

Accepted Solutions
sunny_talwar

seems like a typo with double quotes (after @) m w‌:

SubField(Email, '@', 1) as Name

View solution in original post

3 Replies
m_woolf
Master II
Master II

If you Field is named Email:

subfield(Email,'@",1) as Name,

sunny_talwar

seems like a typo with double quotes (after @) m w‌:

SubField(Email, '@', 1) as Name

Anonymous
Not applicable
Author

Thanks for the help 

Regards Deepanshu