Mike, could you share the python code for splitting the streets out separately rather than all be concatenated with the & symbol? - my python skills are still in the 'early' stage
Luke, don't remember, though someone did put some array stuff up there. If you wanted to do manually, create enough fields for each street, and maybe a working field or two. Use Field Calculator with vb as parser and use InStr() to find location of 1st & and put that value into an integer working field (len). Then use that location to get 1st street using Left(AllStreetsField,len-1) and put remainder into another working field using mid(AllStreetsField,len+1,x) where x=field length - len + 1. then do again against remainder.
Thanks Mike, I'll play around and see if I can come up with something
The reason I'm doing this is because I work for a water company in Florida, so its to compliment a pdf mapbook I'm making in case we have no internet during a hurricane (I don't just randomly look up 7 year old posts I promise )
I really like how all have come up with ideas, why cant ESRI just make a tool to do that. I in my workplace use ET Geowizard tool-->Export Nodes (Regular nodes which carrys UID from centreline) that does in one tool and does not have to worry about it. May be its esri's time to incorporate it in to their new version..
Within the ArcToolBox, Selected Analysis Tools - Overlay - Intersect. Fill out the details in the pop up window and change the output feature type to Point and it will create a point feature from all the places where the two road types intersect. That is the method I use anyway.