topic Re: Trim dynamic string in QlikView https://community.qlik.com/t5/QlikView/Trim-dynamic-string/m-p/1279167#M401364 <HTML><HEAD></HEAD><BODY><P>This will return everything up to (and not including) the second period:</P><P><EM>=Left(yourString, Index(yourString, '.', 2) - 1)</EM></P></BODY></HTML> Thu, 02 Feb 2017 09:12:24 GMT jonathandienst 2017-02-02T09:12:24Z Trim dynamic string https://community.qlik.com/t5/QlikView/Trim-dynamic-string/m-p/1279166#M401363 <HTML><HEAD></HEAD><BODY><P>I have a string which can be in the form of</P><P></P><P>1.1.5 or 16.25.7 or 100.444.111</P><P></P><P>I don't want anything after the 2nd decimal inclusive.</P><P>meaning expected output for the above example is</P><P></P><P>1.1, 16.25 and 100.444</P><P></P><P>I cant use left() because I don't know the exact format&nbsp; which can be any of the above 3 formats. thank you</P></BODY></HTML> Thu, 02 Feb 2017 08:46:49 GMT https://community.qlik.com/t5/QlikView/Trim-dynamic-string/m-p/1279166#M401363 2017-02-02T08:46:49Z Re: Trim dynamic string https://community.qlik.com/t5/QlikView/Trim-dynamic-string/m-p/1279167#M401364 <HTML><HEAD></HEAD><BODY><P>This will return everything up to (and not including) the second period:</P><P><EM>=Left(yourString, Index(yourString, '.', 2) - 1)</EM></P></BODY></HTML> Thu, 02 Feb 2017 09:12:24 GMT https://community.qlik.com/t5/QlikView/Trim-dynamic-string/m-p/1279167#M401364 jonathandienst 2017-02-02T09:12:24Z