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

Question

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?

roadlabels.JPG

StatewideHousingAffordability_dashboard.png

StephenKruzik · Answer

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]

MarcinGasior · Answer

In Label Expression type this expression:Mid([ST_NAME], 4)

for pattern ST-xyz
and Mid([ST_NAME], 3)

for pattern I-xyz

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

KodyGoodwin · Answer

Anybody please?