topic Re: Trimm full stop in QlikView https://community.qlik.com/t5/QlikView/Trimm-full-stop/m-p/1102685#M365547 <HTML><HEAD></HEAD><BODY><P>May be as below:</P><P></P><P>Name_Table:</P><P>Load * Inline [</P><P>Name</P><P>Raja .</P><P>Raja</P><P>Michel .</P><P>Michel</P><P>];</P><P></P><P>NoConcatenate</P><P>Final:</P><P>Load</P><P>SubField(Name,' .',1) as Name</P><P>Resident Name_Table;</P><P></P><P>Drop Table Name_Table;</P></BODY></HTML> Mon, 09 May 2016 09:34:42 GMT trdandamudi 2016-05-09T09:34:42Z Trimm full stop https://community.qlik.com/t5/QlikView/Trimm-full-stop/m-p/1102683#M365545 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>How to trim full stop .</P><P>Name:</P><P>Raja .</P><P>Raja</P><P>Michel .</P><P>Michel</P><P></P><P>Thanks,</P><P>Krishna</P></BODY></HTML> Mon, 09 May 2016 09:28:47 GMT https://community.qlik.com/t5/QlikView/Trimm-full-stop/m-p/1102683#M365545 Anonymous 2016-05-09T09:28:47Z Re: Trimm full stop https://community.qlik.com/t5/QlikView/Trimm-full-stop/m-p/1102684#M365546 <HTML><HEAD></HEAD><BODY><P>Maybe like</P><P></P><P>Trim( Purgechar(Name,'.'))</P></BODY></HTML> Mon, 09 May 2016 09:32:13 GMT https://community.qlik.com/t5/QlikView/Trimm-full-stop/m-p/1102684#M365546 swuehl 2016-05-09T09:32:13Z Re: Trimm full stop https://community.qlik.com/t5/QlikView/Trimm-full-stop/m-p/1102685#M365547 <HTML><HEAD></HEAD><BODY><P>May be as below:</P><P></P><P>Name_Table:</P><P>Load * Inline [</P><P>Name</P><P>Raja .</P><P>Raja</P><P>Michel .</P><P>Michel</P><P>];</P><P></P><P>NoConcatenate</P><P>Final:</P><P>Load</P><P>SubField(Name,' .',1) as Name</P><P>Resident Name_Table;</P><P></P><P>Drop Table Name_Table;</P></BODY></HTML> Mon, 09 May 2016 09:34:42 GMT https://community.qlik.com/t5/QlikView/Trimm-full-stop/m-p/1102685#M365547 trdandamudi 2016-05-09T09:34:42Z Re: Trimm full stop https://community.qlik.com/t5/QlikView/Trimm-full-stop/m-p/1102686#M365548 <HTML><HEAD></HEAD><BODY><P>One more way with preceding load:</P><P></P><P>Name_Table:</P><P>Load SubField(Name,' .',1) as Name;</P><P>Load * Inline [</P><P>Name</P><P>Raja .</P><P>Raja</P><P>Michel .</P><P>Michel</P><P>];</P></BODY></HTML> Mon, 09 May 2016 09:44:33 GMT https://community.qlik.com/t5/QlikView/Trimm-full-stop/m-p/1102686#M365548 trdandamudi 2016-05-09T09:44:33Z Re: Trimm full stop https://community.qlik.com/t5/QlikView/Trimm-full-stop/m-p/1102687#M365549 <HTML><HEAD></HEAD><BODY><P><EM>You can also try,</EM></P><P></P><P><EM>Trim(Replace(</EM><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><EM>Name,'.',''))</EM></SPAN></P></BODY></HTML> Mon, 09 May 2016 09:45:33 GMT https://community.qlik.com/t5/QlikView/Trimm-full-stop/m-p/1102687#M365549 tamilarasu 2016-05-09T09:45:33Z