https://community.qlik.com/t5/QlikView/String-Manipulation/m-p/1538662#M746780 <P><SPAN>=subfield(subfield(Assessment,' - ',2),' - ',1) as Country</SPAN></P> Fri, 01 Feb 2019 22:26:33 GMT j_puri_6601 2019-02-01T22:26:33Z https://community.qlik.com/t5/QlikView/String-Manipulation/m-p/1538635#M746778 <P>Hello everyone,PFA,</P><P>Hello everyone,PFA,</P><P>I would like create a create another column called <STRONG>Country</STRONG> from the column&nbsp;<STRONG>Assessmen</STRONG>t. My expected result is&nbsp;</P><TABLE><TBODY><TR><TD>Assessment</TD><TD>Country</TD></TR><TR><TD>AGLB - NBC Tanzania - CA</TD><TD>NBC Tanzania</TD></TR><TR><TD>AGLB - Ghana - CA</TD><TD>Ghana</TD></TR><TR><TD>AGLB - Kenya - CA</TD><TD>Kenya</TD></TR><TR><TD>AGLB - Mauritius - CA</TD><TD>Mauritius</TD></TR><TR><TD>AGLB - Tanzania - CA</TD><TD>Tanzania</TD></TR></TBODY></TABLE> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/String-Manipulation/m-p/1538635#M746778 zwyne 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/String-Manipulation/m-p/1538640#M746779 <P>=subfield(Assessment,' - ',2) as Country</P> Fri, 01 Feb 2019 20:46:01 GMT https://community.qlik.com/t5/QlikView/String-Manipulation/m-p/1538640#M746779 m_woolf 2019-02-01T20:46:01Z https://community.qlik.com/t5/QlikView/String-Manipulation/m-p/1538662#M746780 <P><SPAN>=subfield(subfield(Assessment,' - ',2),' - ',1) as Country</SPAN></P> Fri, 01 Feb 2019 22:26:33 GMT https://community.qlik.com/t5/QlikView/String-Manipulation/m-p/1538662#M746780 j_puri_6601 2019-02-01T22:26:33Z