topic Re: extract in QlikView https://community.qlik.com/t5/QlikView/extract/m-p/1403626#M425263 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>SubField(Field, '@', 1) as UserID</STRONG></P></BODY></HTML> Fri, 20 Oct 2017 12:04:03 GMT sunny_talwar 2017-10-20T12:04:03Z extract https://community.qlik.com/t5/QlikView/extract/m-p/1403625#M425262 <HTML><HEAD></HEAD><BODY><P>Hello Guys,</P><P></P><P>I need to extract the expression before the @, Any idea how :</P><P></P><P><A class="jive-link-email-small" href="mailto:rymom.golmri@xxxx.tn">rymom.golmri@xxxx.tn</A></P><P></P><P>Thanks a lot</P></BODY></HTML> Fri, 20 Oct 2017 12:01:53 GMT https://community.qlik.com/t5/QlikView/extract/m-p/1403625#M425262 master_student 2017-10-20T12:01:53Z Re: extract https://community.qlik.com/t5/QlikView/extract/m-p/1403626#M425263 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>SubField(Field, '@', 1) as UserID</STRONG></P></BODY></HTML> Fri, 20 Oct 2017 12:04:03 GMT https://community.qlik.com/t5/QlikView/extract/m-p/1403626#M425263 sunny_talwar 2017-10-20T12:04:03Z Re: extract https://community.qlik.com/t5/QlikView/extract/m-p/1403627#M425264 <HTML><HEAD></HEAD><BODY><P>Or this?</P><P></P><P><STRONG>=Left(FieldName,Index(FieldName,'@')-1)</STRONG></P></BODY></HTML> Fri, 20 Oct 2017 12:17:47 GMT https://community.qlik.com/t5/QlikView/extract/m-p/1403627#M425264 Anil_Babu_Samineni 2017-10-20T12:17:47Z