topic How to Extract first five character from any Column?? in QlikView https://community.qlik.com/t5/QlikView/How-to-Extract-first-five-character-from-any-Column/m-p/375793#M1168176 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have one column (Subject) value is (W0696 RE: RE: Employee GID 1000211087).</P><P>Now I want to extract only (W0696). For using which function I got this???</P></BODY></HTML> Tue, 31 Jul 2012 12:12:18 GMT jsingh71 2012-07-31T12:12:18Z How to Extract first five character from any Column?? https://community.qlik.com/t5/QlikView/How-to-Extract-first-five-character-from-any-Column/m-p/375793#M1168176 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have one column (Subject) value is (W0696 RE: RE: Employee GID 1000211087).</P><P>Now I want to extract only (W0696). For using which function I got this???</P></BODY></HTML> Tue, 31 Jul 2012 12:12:18 GMT https://community.qlik.com/t5/QlikView/How-to-Extract-first-five-character-from-any-Column/m-p/375793#M1168176 jsingh71 2012-07-31T12:12:18Z Re: How to Extract first five character from any Column?? https://community.qlik.com/t5/QlikView/How-to-Extract-first-five-character-from-any-Column/m-p/375794#M1168177 <HTML><HEAD></HEAD><BODY><P>left(Subject, 5)</P><P></P><P>or</P><P></P><P>subfield(Subject, ' ', 1)</P></BODY></HTML> Tue, 31 Jul 2012 12:14:13 GMT https://community.qlik.com/t5/QlikView/How-to-Extract-first-five-character-from-any-Column/m-p/375794#M1168177 Nicole-Smith 2012-07-31T12:14:13Z