topic Extract data after a &quot;.&quot; in QlikView https://community.qlik.com/t5/QlikView/Extract-data-after-a-quot-quot/m-p/1392290#M423162 <HTML><HEAD></HEAD><BODY><P>I have information as follows:</P><P>12.1234</P><P>12.1111</P><P>12.33445</P><P>12.13344</P><P></P><P>I need to get the numbers after the dots in each transaction. How can I do that in the load script?</P><P></P><P>Please help.</P><P></P><P>Thanks,<BR />Amit</P></BODY></HTML> Wed, 18 Oct 2017 18:56:33 GMT Anonymous 2017-10-18T18:56:33Z Extract data after a "." https://community.qlik.com/t5/QlikView/Extract-data-after-a-quot-quot/m-p/1392290#M423162 <HTML><HEAD></HEAD><BODY><P>I have information as follows:</P><P>12.1234</P><P>12.1111</P><P>12.33445</P><P>12.13344</P><P></P><P>I need to get the numbers after the dots in each transaction. How can I do that in the load script?</P><P></P><P>Please help.</P><P></P><P>Thanks,<BR />Amit</P></BODY></HTML> Wed, 18 Oct 2017 18:56:33 GMT https://community.qlik.com/t5/QlikView/Extract-data-after-a-quot-quot/m-p/1392290#M423162 Anonymous 2017-10-18T18:56:33Z Re: Extract data after a "." https://community.qlik.com/t5/QlikView/Extract-data-after-a-quot-quot/m-p/1392291#M423163 <HTML><HEAD></HEAD><BODY><P>In Load string try with</P><P></P><P>Load </P><P>Trim(SubField(StrCol,'.',-1)) as NewStringColumn</P><P>From Source......</P></BODY></HTML> Wed, 18 Oct 2017 19:10:57 GMT https://community.qlik.com/t5/QlikView/Extract-data-after-a-quot-quot/m-p/1392291#M423163 its_anandrjs 2017-10-18T19:10:57Z Re: Extract data after a "." https://community.qlik.com/t5/QlikView/Extract-data-after-a-quot-quot/m-p/1392292#M423164 <HTML><HEAD></HEAD><BODY><P>Thanks man!</P></BODY></HTML> Wed, 18 Oct 2017 19:14:18 GMT https://community.qlik.com/t5/QlikView/Extract-data-after-a-quot-quot/m-p/1392292#M423164 Anonymous 2017-10-18T19:14:18Z