topic Re: How to Search in String in QlikView https://community.qlik.com/t5/QlikView/How-to-Search-in-String/m-p/685389#M248389 <HTML><HEAD></HEAD><BODY><P>substring(yourfieldname, '/',-1) as newfield</P></BODY></HTML> Thu, 23 Oct 2014 16:17:56 GMT 2014-10-23T16:17:56Z How to Search in String https://community.qlik.com/t5/QlikView/How-to-Search-in-String/m-p/685387#M248387 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a string which has different values in it, it was delimited with '/'. How to get last keyword in string. sometimes it was after 5th '/' and some time its after 4th '/' from starting. Is there anyway to get sub field from the end?</P><P></P><P>eg: </P><P>1)asr/098/yes/bcd/in</P><P>2)nfd/234/upl/nmd/a90/pak</P><P></P><P>OutPut: </P><P>1)in</P><P>2)pak</P></BODY></HTML> Thu, 23 Oct 2014 16:07:44 GMT https://community.qlik.com/t5/QlikView/How-to-Search-in-String/m-p/685387#M248387 Anonymous 2014-10-23T16:07:44Z Re: How to Search in String https://community.qlik.com/t5/QlikView/How-to-Search-in-String/m-p/685388#M248388 <HTML><HEAD></HEAD><BODY><P>Load SubField(Txt,'/',-1) Inline [</P><P>Txt</P><P>asr/098/yes/bcd/in</P><P>nfd/234/upl/nmd/a90/pak ];</P></BODY></HTML> Thu, 23 Oct 2014 16:13:04 GMT https://community.qlik.com/t5/QlikView/How-to-Search-in-String/m-p/685388#M248388 anbu1984 2014-10-23T16:13:04Z Re: How to Search in String https://community.qlik.com/t5/QlikView/How-to-Search-in-String/m-p/685389#M248389 <HTML><HEAD></HEAD><BODY><P>substring(yourfieldname, '/',-1) as newfield</P></BODY></HTML> Thu, 23 Oct 2014 16:17:56 GMT https://community.qlik.com/t5/QlikView/How-to-Search-in-String/m-p/685389#M248389 2014-10-23T16:17:56Z Re: How to Search in String https://community.qlik.com/t5/QlikView/How-to-Search-in-String/m-p/685390#M248390 <HTML><HEAD></HEAD><BODY><P>=SubField(YourFieldName,'/',-1)</P></BODY></HTML> Thu, 23 Oct 2014 16:24:25 GMT https://community.qlik.com/t5/QlikView/How-to-Search-in-String/m-p/685390#M248390 MK_QSL 2014-10-23T16:24:25Z Re: How to Search in String https://community.qlik.com/t5/QlikView/How-to-Search-in-String/m-p/685391#M248391 <HTML><HEAD></HEAD><BODY><P>Hi Anbu,</P><P></P><P>It's working, Thank you</P></BODY></HTML> Thu, 23 Oct 2014 16:24:49 GMT https://community.qlik.com/t5/QlikView/How-to-Search-in-String/m-p/685391#M248391 Anonymous 2014-10-23T16:24:49Z