shrug-l: Label Expressions

Tejaswi Tharakabhushanam ttharaka@camsys.com
Tue, 11 Jan 2005 12:01:32 -0500


This is a multipart message in MIME format.
--=_alternative 005D848685256F86_=
Content-Type: text/plain; charset="US-ASCII"

Hey
In the labels tab of the layer properties

Click on Expressions and paste this

Mid([Label field name],5, 10)


Make sure the Parser is VB script


Hope this helps..

Teju

Tejaswi Tharakabhushanam
Cambridge Systematics, Inc.
1820 East Park Avenue, Suite 203
Tallahassee, FL  32301
tel  850 219 6388 
fax  850 219 6389
e-mail  ttharaka@camsys.com
www.camsys.com



"Nonie Castro" <nonie_castro@coxtarget.com> 
Sent by: shrug-l-admin@lists.dep.state.fl.us
01/11/2005 11:46 AM

To
<shrug-l@lists.dep.state.fl.us>
cc

Subject
shrug-l: Label Expressions






This is probably a really simple question - I apologize!

I have a table with a list of 6 and 7 digit records. 
I want to make labels that will disregard the first four digits. 

So I am showing: 
3441AA
3441BB
3441DD
3224ABC
3224DEF
3224GHI

And I only want to show the alpha part on the labels. 
How do I do this? 

Thank you,
Nonie Castro
GIS Specialist
Cox Target Media
8605 Largo Lakes Blvd
Largo, FL 33773
727-399-3000 x3246
www.coxtarget.com

_______________________________________________
SHRUG-L mailing list
SHRUG-L@lists.dep.state.fl.us
http://lists.dep.state.fl.us/mailman/listinfo/shrug-l


--=_alternative 005D848685256F86_=
Content-Type: text/html; charset="US-ASCII"


<br><font size=2 face="sans-serif">Hey</font>
<br><font size=2 face="sans-serif">In the labels tab of the layer properties</font>
<br>
<br><font size=2 face="sans-serif">Click on Expressions and paste this</font>
<br>
<br><font size=2 face="sans-serif"><i>Mid([<b>Label field name</i></b><i>],5,
10)</i></font>
<br>
<br>
<br><font size=2 face="sans-serif">Make sure the Parser is VB script</font>
<br>
<br>
<br><font size=2 face="sans-serif">Hope this helps..</font>
<br>
<br><font size=2 face="sans-serif">Teju</font>
<br><font size=2 face="sans-serif"><br>
Tejaswi Tharakabhushanam<br>
Cambridge Systematics, Inc.<br>
1820 East Park Avenue, Suite 203<br>
Tallahassee, FL &nbsp;32301<br>
tel &nbsp;850 219 6388 &nbsp;<br>
fax &nbsp;850 219 6389<br>
e-mail &nbsp;ttharaka@camsys.com<br>
www.camsys.com</font>
<br>
<br>
<br>
<table width=100%>
<tr valign=top>
<td width=40%><font size=1 face="sans-serif"><b>&quot;Nonie Castro&quot;
&lt;nonie_castro@coxtarget.com&gt;</b> </font>
<br><font size=1 face="sans-serif">Sent by: shrug-l-admin@lists.dep.state.fl.us</font>
<p><font size=1 face="sans-serif">01/11/2005 11:46 AM</font>
<td width=59%>
<table width=100%>
<tr>
<td>
<div align=right><font size=1 face="sans-serif">To</font></div>
<td valign=top><font size=1 face="sans-serif">&lt;shrug-l@lists.dep.state.fl.us&gt;</font>
<tr>
<td>
<div align=right><font size=1 face="sans-serif">cc</font></div>
<td valign=top>
<tr>
<td>
<div align=right><font size=1 face="sans-serif">Subject</font></div>
<td valign=top><font size=1 face="sans-serif">shrug-l: Label Expressions</font></table>
<br>
<table>
<tr valign=top>
<td>
<td></table>
<br></table>
<br>
<br>
<br><font size=2><tt>This is probably a really simple question - I apologize!<br>
<br>
I have a table with a list of 6 and 7 digit records. <br>
I want to make labels that will disregard the first four digits. <br>
<br>
So I am showing: <br>
3441AA<br>
3441BB<br>
3441DD<br>
3224ABC<br>
3224DEF<br>
3224GHI<br>
<br>
And I only want to show the alpha part on the labels. <br>
How do I do this? <br>
<br>
Thank you,<br>
Nonie Castro<br>
GIS Specialist<br>
Cox Target Media<br>
8605 Largo Lakes Blvd<br>
Largo, FL 33773<br>
727-399-3000 x3246<br>
www.coxtarget.com<br>
<br>
_______________________________________________<br>
SHRUG-L mailing list<br>
SHRUG-L@lists.dep.state.fl.us<br>
http://lists.dep.state.fl.us/mailman/listinfo/shrug-l<br>
</tt></font>
<br>
--=_alternative 005D848685256F86_=--