topic Re: Get substring from string in QlikView https://community.qlik.com/t5/QlikView/Get-substring-from-string/m-p/1036092#M349247 <HTML><HEAD></HEAD><BODY><P>Ah this was so simple but saw it as more complicated than it really is. Thanks!</P></BODY></HTML> Mon, 15 Feb 2016 15:56:41 GMT sifatnabil 2016-02-15T15:56:41Z Get substring from string https://community.qlik.com/t5/QlikView/Get-substring-from-string/m-p/1036088#M349243 <HTML><HEAD></HEAD><BODY><P> Hi all,</P><P></P><P>I have a string like this: </P><P></P><P><SPAN style="color: #ff0000;">* 11.500%</SPAN>|<STRONG>955597946785402</STRONG>|10-Oct-2018|11.500</P><P></P><P>I need to get the bolded part but the part in red is arbitrary in length. Is there a good way to get this? </P></BODY></HTML> Mon, 15 Feb 2016 14:37:31 GMT https://community.qlik.com/t5/QlikView/Get-substring-from-string/m-p/1036088#M349243 sifatnabil 2016-02-15T14:37:31Z Re: Get substring from string https://community.qlik.com/t5/QlikView/Get-substring-from-string/m-p/1036089#M349244 <HTML><HEAD></HEAD><BODY><P>Use: subfield(YourField, '|', 2)</P><P></P><P>- Marcus</P></BODY></HTML> Mon, 15 Feb 2016 14:40:28 GMT https://community.qlik.com/t5/QlikView/Get-substring-from-string/m-p/1036089#M349244 marcus_sommer 2016-02-15T14:40:28Z Re: Get substring from string https://community.qlik.com/t5/QlikView/Get-substring-from-string/m-p/1036090#M349245 <HTML><HEAD></HEAD><BODY><P>Use the <STRONG>subfield</STRONG> command</P><P></P><P>subfield(YourFieldName, '|', 2)</P><P></P><P>subfield('<SPAN style="color: #ff0000;">11.500%</SPAN>|<STRONG>955597946785402</STRONG>|10-Oct-2018|11.500', '|', 2)&nbsp; will return <STRONG>955597946785402</STRONG></P></BODY></HTML> Mon, 15 Feb 2016 14:41:50 GMT https://community.qlik.com/t5/QlikView/Get-substring-from-string/m-p/1036090#M349245 Colin-Albert 2016-02-15T14:41:50Z Re: Get substring from string https://community.qlik.com/t5/QlikView/Get-substring-from-string/m-p/1036091#M349246 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Subfield() should do it:</P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/114663_Capture.PNG" style="height: auto;" /></P><P><IMG alt="Capture.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/114664_Capture.PNG" style="height: auto;" /></P><P>Thanks</P></BODY></HTML> Mon, 15 Feb 2016 14:42:29 GMT https://community.qlik.com/t5/QlikView/Get-substring-from-string/m-p/1036091#M349246 sinanozdemir 2016-02-15T14:42:29Z Re: Get substring from string https://community.qlik.com/t5/QlikView/Get-substring-from-string/m-p/1036092#M349247 <HTML><HEAD></HEAD><BODY><P>Ah this was so simple but saw it as more complicated than it really is. Thanks!</P></BODY></HTML> Mon, 15 Feb 2016 15:56:41 GMT https://community.qlik.com/t5/QlikView/Get-substring-from-string/m-p/1036092#M349247 sifatnabil 2016-02-15T15:56:41Z