topic Re: Remove the unwanted name in App Development

Remove the unwanted name

Anonymous — Tue, 16 Feb 2016 19:29:21 GMT

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

Re: Remove the unwanted name

m_woolf — Tue, 16 Feb 2016 20:08:44 GMT

If you Field is named Email:

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

Re: Remove the unwanted name

sunny_talwar — Tue, 16 Feb 2016 21:02:00 GMT

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

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

Re: Remove the unwanted name

Anonymous — Sat, 20 Feb 2016 13:51:55 GMT

Thanks for the help

Regards Deepanshu