Guys,
See attached and also refer to the other stuff.
The deal is is that NAP ‘xxx’ can a 3-4 letter character string or a space between spaces. It’s the variability of what needs to be changed to the even bigger variability in terms of the number of text strings that could go in front of the space between the 3 -4 character string or the space AND the R or L or other space before a 6 digit string representing a number.
I did come up with a partial solution, where I created a text string in MS Excel with a dash before and after the route number; this text string would replace the 2nd set of characters, but again, the variability of the size of the string is a kicker.
How does any of what you guys are suggesting deal with this?
Yes it would cover for some of what the bigger formula was getting at with the “ -121- “ part, but again, not one string fits all. I even had to edit 29 to become 029 because it wasn’t in a consistent 3 digit format like the other route.
The second string is nearly out the window in terms of variability of starting position and numbers of characters. But again, I didn’t have a problem editing the characters and the text strings as need be.
Seriously I do thank you for this.
Daniel T. Brenner
RESEARCH ANALYST I (GEOGRAPHIC INFORMATION SYSTEMS)
DIVISION OF RESEARCH, INNOVATION, and SYSTEM INFORMATION
Highway System Information and Performance
1120 N Street MS 38
Sacramento, CA 95814
(916) 657-4277
(510) 593-7547 cell
daniel.brenner@dot.ca.gov<mailto:daniel.brenner@dot.ca.gov>
“Consider the unconsidered.”
“Certainty is not a sure thing!”