I would like to find out how to properly format a conditional expression in labeling, so as to only get specific characters back out of a field that has 9 characters in it, but don't wish to label them on the map in full.
Sadly, I am not the best in scripting languages, I know a bit SQL but I see labeling or does VBscript, Jscript, or Python.
I've thus far been able to drop the first two characters, but I am not familiar how to get to the part where I keep certain characters and skip others.
[FACILITYID] WF2820001, WF3540034, etc...
What I have so far built in VBscript is as follows
Function FindLabel ( [FACILITYID] ) FindLabel = mid ([FACILITYID],3,50) End Function
This is at least dropping off the WF that doesn't need labeled. I wish to then have two characters remain, insert a '-' symbol, keep one character, drop the zeros and replace with a tilda ~ symbol and keep the last one or two numbers if their anything higher than 01.
Example data would have this input
[FACILITYID] WF2820001, WF3540034 and would then come back with