topic trimming data in QlikView https://community.qlik.com/t5/QlikView/trimming-data/m-p/214117#M67703 <HTML><HEAD></HEAD><BODY><P>try this:</P><P></P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;"><BR />left(HostName,index(HostName,'.')-1) as HostNameShort<BR /></PRE></BLOCKQUOTE><BR /><BR /></BODY></HTML> Mon, 12 Oct 2009 21:46:03 GMT 2009-10-12T21:46:03Z trimming data https://community.qlik.com/t5/QlikView/trimming-data/m-p/214116#M67702 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P>I have some data which I would like to 'trim' where anything after the 'full stop' is removed so bbc.co.uk would simple be bbc</P><P>I treid using the code below but that didn't seem to work.</P><P></P><P></P><P>left</P><P></P><P>(HostName, index(HostName, '.') -1) <B>as</B> HostNameShort</P><P>Any suggestions?</P><P>Thanks</P><BR /><BR /> <BR /><BR /></BODY></HTML> Mon, 12 Oct 2009 21:37:08 GMT https://community.qlik.com/t5/QlikView/trimming-data/m-p/214116#M67702 2009-10-12T21:37:08Z trimming data https://community.qlik.com/t5/QlikView/trimming-data/m-p/214117#M67703 <HTML><HEAD></HEAD><BODY><P>try this:</P><P></P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;"><BR />left(HostName,index(HostName,'.')-1) as HostNameShort<BR /></PRE></BLOCKQUOTE><BR /><BR /></BODY></HTML> Mon, 12 Oct 2009 21:46:03 GMT https://community.qlik.com/t5/QlikView/trimming-data/m-p/214117#M67703 2009-10-12T21:46:03Z trimming data https://community.qlik.com/t5/QlikView/trimming-data/m-p/214118#M67704 <HTML><HEAD></HEAD><BODY><P>Is that not the same as I wrote? I think you may have missed the 'left' at the top of my code <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P></BODY></HTML> Mon, 12 Oct 2009 21:52:23 GMT https://community.qlik.com/t5/QlikView/trimming-data/m-p/214118#M67704 2009-10-12T21:52:23Z trimming data https://community.qlik.com/t5/QlikView/trimming-data/m-p/214119#M67705 <HTML><HEAD></HEAD><BODY><P>you're right, I didn't see that left at the top o_O</P><P>then try with trim, I'm guessing you may have some spaces around the ends.</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;"><BR />left(trim(HostName),index(trim(HostName),'.')-1) as HostNameShort<BR /></PRE></BLOCKQUOTE><BR /><BR /> <P></P><P></P></BODY></HTML> Mon, 12 Oct 2009 21:59:25 GMT https://community.qlik.com/t5/QlikView/trimming-data/m-p/214119#M67705 2009-10-12T21:59:25Z