https://community.qlik.com/t5/QlikView/always-hide-5-from-left/m-p/1613193#M735765 <P>here are some options:</P><UL><LI>subfield('10.10.10.10:2323', ':', 1)</LI><LI>left( '10.10.10.10:2323', len('10.10.10.10:2323')-5)</LI><LI>mid( '10.10.10.10:2323', 1, len('10.10.10.10:2323')-5)</LI></UL> Fri, 16 Aug 2019 09:56:19 GMT Gysbert_Wassenaar 2019-08-16T09:56:19Z https://community.qlik.com/t5/QlikView/always-hide-5-from-left/m-p/1613191#M735764 <P>I have 10.10.10.10:2323</P><P>Just want to have 10.10.10.10&nbsp;</P><P>Left, right, mid? My brain is killing me <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/always-hide-5-from-left/m-p/1613191#M735764 johnan 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/always-hide-5-from-left/m-p/1613193#M735765 <P>here are some options:</P><UL><LI>subfield('10.10.10.10:2323', ':', 1)</LI><LI>left( '10.10.10.10:2323', len('10.10.10.10:2323')-5)</LI><LI>mid( '10.10.10.10:2323', 1, len('10.10.10.10:2323')-5)</LI></UL> Fri, 16 Aug 2019 09:56:19 GMT https://community.qlik.com/t5/QlikView/always-hide-5-from-left/m-p/1613193#M735765 Gysbert_Wassenaar 2019-08-16T09:56:19Z https://community.qlik.com/t5/QlikView/always-hide-5-from-left/m-p/1613194#M735766 <P>Haha, Big thanx, so easy but my brain says friday <span class="lia-unicode-emoji" title=":grinning_face_with_smiling_eyes:">😄</span></P> Fri, 16 Aug 2019 09:58:37 GMT https://community.qlik.com/t5/QlikView/always-hide-5-from-left/m-p/1613194#M735766 johnan 2019-08-16T09:58:37Z