topic Re: Use Different Text for Road Label (75 NOT I-75) in Transportation Questions

Use Different Text for Road Label (75 NOT I-75)

KodyGoodwin — Thu, 24 May 2012 19:12:21 GMT

I am working with a shapefile for roads. In its attribute table the field 'ST_NAME' contains the road names. The problem is I only want to show numbers and not the letters preceding them. In the picture you can see the letters and numbers are within the shields.

[ATTACH=CONFIG]14612[/ATTACH]

Is there a SQL query or definition query I could use to change the labels?

Re: Use Different Text for Road Label (75 NOT I-75)

KodyGoodwin — Wed, 30 May 2012 15:21:33 GMT

Anybody please?

Re: Use Different Text for Road Label (75 NOT I-75)

MarcinGasior — Thu, 31 May 2012 04:32:39 GMT

In Label Expression type this expression:

Mid([ST_NAME], 4)

for pattern ST-XXX
and

Mid([ST_NAME], 3)

for pattern I-XX

Mid() function returns all characters starting from a number provided.

Re: Use Different Text for Road Label (75 NOT I-75)

StephenKruzik — Thu, 31 May 2012 11:06:53 GMT

As long as every record has a "-" separating the road type, and the route number you could try this

In the label expression, check 'advanced' and paste the following

[HTML]Function FindLabel ( [ST_NAME] )
a = split( [ST_NAME] ,"-")
b = a(1)
FindLabel = b
End Function[/HTML]