topic Re: Only Characters after last . in String in QlikView https://community.qlik.com/t5/QlikView/Only-Characters-after-last-in-String/m-p/508065#M189938 <HTML><HEAD></HEAD><BODY><P>thanks tresesco</P></BODY></HTML> Thu, 03 Oct 2013 11:42:55 GMT rustyfishbones 2013-10-03T11:42:55Z Only Characters after last . in String https://community.qlik.com/t5/QlikView/Only-Characters-after-last-in-String/m-p/508063#M189936 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have file paths and I am using the following to get everything after a '.' or CHAR(46)</P><P></P><P>SUBFIELD([Full Path],'.',2)</P><P></P><P>However some file paths contain a number of&nbsp; '.' but i only want everything after the last one</P><P></P><P>So if I have</P><P></P><P>Alan.qvw</P><P>Alan.Farrell.qvw</P><P>Alan.r</P><P>Alan.Farrell.r </P><P></P><P>I only want to see </P><P></P><P>.qvw</P><P>.r</P><P></P><P>Regards</P><P></P><P>Alan</P></BODY></HTML> Thu, 03 Oct 2013 11:05:59 GMT https://community.qlik.com/t5/QlikView/Only-Characters-after-last-in-String/m-p/508063#M189936 rustyfishbones 2013-10-03T11:05:59Z Re: Only Characters after last . in String https://community.qlik.com/t5/QlikView/Only-Characters-after-last-in-String/m-p/508064#M189937 <HTML><HEAD></HEAD><BODY><P>Try:</P><P>SUBFIELD([Full Path],'.', <STRONG>-1</STRONG>)</P></BODY></HTML> Thu, 03 Oct 2013 11:10:30 GMT https://community.qlik.com/t5/QlikView/Only-Characters-after-last-in-String/m-p/508064#M189937 tresB 2013-10-03T11:10:30Z Re: Only Characters after last . in String https://community.qlik.com/t5/QlikView/Only-Characters-after-last-in-String/m-p/508065#M189938 <HTML><HEAD></HEAD><BODY><P>thanks tresesco</P></BODY></HTML> Thu, 03 Oct 2013 11:42:55 GMT https://community.qlik.com/t5/QlikView/Only-Characters-after-last-in-String/m-p/508065#M189938 rustyfishbones 2013-10-03T11:42:55Z