topic Re: how to use substr in QlikView https://community.qlik.com/t5/QlikView/how-to-use-substr/m-p/1222115#M857519 <HTML><HEAD></HEAD><BODY><P>Or <SPAN class="statement" style="font-weight: bold; color: #0f0f0f; font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; font-size: 12px;">Mid(part_id</SPAN><SPAN style="color: #0f0f0f; font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; font-size: 12px; background-color: #f4f4f4;">, findoneof (part_I'd, '_')</SPAN><SPAN class="statement" style="font-weight: bold; color: #0f0f0f; font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; font-size: 12px;">)</SPAN></P></BODY></HTML> Tue, 24 Jan 2017 06:41:57 GMT vinieme12 2017-01-24T06:41:57Z how to use substr https://community.qlik.com/t5/QlikView/how-to-use-substr/m-p/1222113#M857517 <HTML><HEAD></HEAD><BODY><P>Hi Friends,</P><P></P><P></P><P>I have substr function.</P><P></P><P></P><P>I have part_id(123456_786789) i need after _786789 value how can i get.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/how-to-use-substr/m-p/1222113#M857517 2020-11-25T16:16:04Z Re: how to use substr https://community.qlik.com/t5/QlikView/how-to-use-substr/m-p/1222114#M857518 <HTML><HEAD></HEAD><BODY><P>For the above you can use</P><P>Subfield (part_id,'_',2)</P><P></P><P>Other string functions</P><P><A href="https://help.qlik.com/en-US/sense/3.1/Subsystems/Hub/Content/Scripting/StringFunctions/SubField.htm" title="https://help.qlik.com/en-US/sense/3.1/Subsystems/Hub/Content/Scripting/StringFunctions/SubField.htm">https://help.qlik.com/en-US/sense/3.1/Subsystems/Hub/Content/Scripting/StringFunctions/SubField.htm</A></P></BODY></HTML> Tue, 24 Jan 2017 06:39:02 GMT https://community.qlik.com/t5/QlikView/how-to-use-substr/m-p/1222114#M857518 vinieme12 2017-01-24T06:39:02Z Re: how to use substr https://community.qlik.com/t5/QlikView/how-to-use-substr/m-p/1222115#M857519 <HTML><HEAD></HEAD><BODY><P>Or <SPAN class="statement" style="font-weight: bold; color: #0f0f0f; font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; font-size: 12px;">Mid(part_id</SPAN><SPAN style="color: #0f0f0f; font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; font-size: 12px; background-color: #f4f4f4;">, findoneof (part_I'd, '_')</SPAN><SPAN class="statement" style="font-weight: bold; color: #0f0f0f; font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; font-size: 12px;">)</SPAN></P></BODY></HTML> Tue, 24 Jan 2017 06:41:57 GMT https://community.qlik.com/t5/QlikView/how-to-use-substr/m-p/1222115#M857519 vinieme12 2017-01-24T06:41:57Z Re: how to use substr https://community.qlik.com/t5/QlikView/how-to-use-substr/m-p/1222116#M857520 <HTML><HEAD></HEAD><BODY><P>'_'&amp; SubField(YourFieldName,'_',-1) as YourFieldName</P><P>or</P><P>as Vineet has suggested..</P></BODY></HTML> Tue, 24 Jan 2017 07:28:42 GMT https://community.qlik.com/t5/QlikView/how-to-use-substr/m-p/1222116#M857520 MK_QSL 2017-01-24T07:28:42Z