topic How to remove characters in a label? in Mining Questions https://community.esri.com/t5/mining-questions/how-to-remove-characters-in-a-label/m-p/210319#M97 <HTML><HEAD></HEAD><BODY><P>How can I&nbsp;have the labeling REMOVE&nbsp;the last 10 characters in a label?</P></BODY></HTML> Wed, 20 Feb 2019 13:39:58 GMT CharlesSchwarz 2019-02-20T13:39:58Z How to remove characters in a label? https://community.esri.com/t5/mining-questions/how-to-remove-characters-in-a-label/m-p/210319#M97 <HTML><HEAD></HEAD><BODY><P>How can I&nbsp;have the labeling REMOVE&nbsp;the last 10 characters in a label?</P></BODY></HTML> Wed, 20 Feb 2019 13:39:58 GMT https://community.esri.com/t5/mining-questions/how-to-remove-characters-in-a-label/m-p/210319#M97 CharlesSchwarz 2019-02-20T13:39:58Z Re: How to remove characters in a label? https://community.esri.com/t5/mining-questions/how-to-remove-characters-in-a-label/m-p/210320#M98 <HTML><HEAD></HEAD><BODY><P>Charles - you can use the following VBScript label expression to do that:</P><P></P><P><STRONG>Function FindLabel ( [COMMENT] )</STRONG><BR /><STRONG> strL = (LEN([COMMENT])-10)</STRONG><BR /><STRONG> if strL &gt; 0 then</STRONG><BR /><STRONG> FindLabel = MID([COMMENT], 1, strL)</STRONG><BR /><STRONG> else</STRONG><BR /><STRONG> FindLabel = [COMMENT]</STRONG><BR /><STRONG> end if</STRONG><BR /><STRONG>End Function</STRONG></P><P></P><P>See screen capture below.&nbsp; Just replace <!-- with the name of the field you want to use.</p><p></p><p><img alt='Label Expression screengrab' class="image-1 jive-image j-img-original" src='/legacyfs/online/437724_TrimLast10CharactersInLabelEpression.PNG' /></p><p>Jay</p></body> --></P></BODY></HTML> Wed, 20 Feb 2019 16:41:59 GMT https://community.esri.com/t5/mining-questions/how-to-remove-characters-in-a-label/m-p/210320#M98 JayJohnsonWashoeCounty 2019-02-20T16:41:59Z