topic Re: Take specifict text in QlikView https://community.qlik.com/t5/QlikView/Take-specifict-text/m-p/113661#M17601 <HTML><HEAD></HEAD><BODY><P>Try</P><P></P><P>SubField(UBERLANDIA-MG,'-',-2) </P></BODY></HTML> Wed, 22 Aug 2018 20:45:30 GMT MarioCenteno 2018-08-22T20:45:30Z Take specifict text https://community.qlik.com/t5/QlikView/Take-specifict-text/m-p/113659#M17599 <HTML><HEAD></HEAD><BODY><P>Hello dear all!</P><P></P><P>I have this column and need to take text after "-" like this:</P><P></P><P>UBERLANDIA-MG&nbsp;&nbsp; -&gt; MG</P><P>JOAO PESSOA-PB&nbsp; -&gt; PB</P><P></P><P>Anyone help me? Is there something like regular expression?</P></BODY></HTML> Wed, 22 Aug 2018 20:41:38 GMT https://community.qlik.com/t5/QlikView/Take-specifict-text/m-p/113659#M17599 breno_morais 2018-08-22T20:41:38Z Re: Take specifict text https://community.qlik.com/t5/QlikView/Take-specifict-text/m-p/113660#M17600 <HTML><HEAD></HEAD><BODY><P>Try this</P><P></P><P>SubField('UBERLANDIA-MG', '-', 2)</P><P></P><P><A href="https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/Scripting/StringFunctions/SubField.htm" title="https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/Scripting/StringFunctions/SubField.htm">https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/Scripting/StringFunctions/SubField.htm</A></P></BODY></HTML> Wed, 22 Aug 2018 20:44:46 GMT https://community.qlik.com/t5/QlikView/Take-specifict-text/m-p/113660#M17600 vamsee 2018-08-22T20:44:46Z Re: Take specifict text https://community.qlik.com/t5/QlikView/Take-specifict-text/m-p/113661#M17601 <HTML><HEAD></HEAD><BODY><P>Try</P><P></P><P>SubField(UBERLANDIA-MG,'-',-2) </P></BODY></HTML> Wed, 22 Aug 2018 20:45:30 GMT https://community.qlik.com/t5/QlikView/Take-specifict-text/m-p/113661#M17601 MarioCenteno 2018-08-22T20:45:30Z Re: Take specifict text https://community.qlik.com/t5/QlikView/Take-specifict-text/m-p/113662#M17602 <HTML><HEAD></HEAD><BODY><P>Works. Thank you! </P></BODY></HTML> Wed, 22 Aug 2018 20:47:16 GMT https://community.qlik.com/t5/QlikView/Take-specifict-text/m-p/113662#M17602 breno_morais 2018-08-22T20:47:16Z