topic Re: Extract Specific String ... in QlikView https://community.qlik.com/t5/QlikView/Extract-Specific-String/m-p/423473#M157858 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Try like this</P><P></P><P>subfield(Country, ' ',2)</P></BODY></HTML> Mon, 10 Dec 2012 23:10:21 GMT MayilVahanan 2012-12-10T23:10:21Z Extract Specific String ... https://community.qlik.com/t5/QlikView/Extract-Specific-String/m-p/423469#M157854 <HTML><HEAD></HEAD><BODY><P>Hi All, </P><P></P><P></P><P>1) I have a fied "Country" with values as </P><P><IMG __jive_id="26637" class="jive-image" alt="Capture.JPG" src="https://community.qlik.com/legacyfs/online/26637_Capture.JPG" /></P><P>My output should be as follows </P><P></P><P><IMG __jive_id="26638" class="jive-image" alt="Capture2.JPG" src="https://community.qlik.com/legacyfs/online/26638_Capture2.JPG" /></P><P>Appreciate help on this ...</P></BODY></HTML> Mon, 10 Dec 2012 22:39:28 GMT https://community.qlik.com/t5/QlikView/Extract-Specific-String/m-p/423469#M157854 2012-12-10T22:39:28Z Re: Extract Specific String ... https://community.qlik.com/t5/QlikView/Extract-Specific-String/m-p/423470#M157855 <HTML><HEAD></HEAD><BODY><P>you can use subfield(Country, ' ',2)</P></BODY></HTML> Mon, 10 Dec 2012 22:48:15 GMT https://community.qlik.com/t5/QlikView/Extract-Specific-String/m-p/423470#M157855 2012-12-10T22:48:15Z Re: Extract Specific String ... https://community.qlik.com/t5/QlikView/Extract-Specific-String/m-p/423471#M157856 <HTML><HEAD></HEAD><BODY><P>You can also use </P><P></P><P><SPAN style="font-size: 10pt;">=<SPAN style="color: #0000ff;">Right</SPAN>(<SPAN style="color: #800000;">Name</SPAN>,<SPAN style="color: #0000ff;">Len</SPAN>(<SPAN style="color: #800000;">Name</SPAN>)-8) </SPAN></P><P></P><P>if they are all in the same format.</P></BODY></HTML> Mon, 10 Dec 2012 22:51:52 GMT https://community.qlik.com/t5/QlikView/Extract-Specific-String/m-p/423471#M157856 2012-12-10T22:51:52Z Re: Extract Specific String ... https://community.qlik.com/t5/QlikView/Extract-Specific-String/m-p/423472#M157857 <HTML><HEAD></HEAD><BODY><P>With Name as your field name of course.</P></BODY></HTML> Mon, 10 Dec 2012 22:52:15 GMT https://community.qlik.com/t5/QlikView/Extract-Specific-String/m-p/423472#M157857 2012-12-10T22:52:15Z Re: Extract Specific String ... https://community.qlik.com/t5/QlikView/Extract-Specific-String/m-p/423473#M157858 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Try like this</P><P></P><P>subfield(Country, ' ',2)</P></BODY></HTML> Mon, 10 Dec 2012 23:10:21 GMT https://community.qlik.com/t5/QlikView/Extract-Specific-String/m-p/423473#M157858 MayilVahanan 2012-12-10T23:10:21Z Re: Extract Specific String ... https://community.qlik.com/t5/QlikView/Extract-Specific-String/m-p/423474#M157859 <HTML><HEAD></HEAD><BODY><P>Good replies</P><P>!!!!!</P></BODY></HTML> Tue, 11 Dec 2012 05:04:39 GMT https://community.qlik.com/t5/QlikView/Extract-Specific-String/m-p/423474#M157859 sujeetsingh 2012-12-11T05:04:39Z