Extracting Road Names for Beginning and End Locations

Question

Greetings,

I have a network of roads with street names. I created point features of beginning and end vertices of the lines to get the road names of intersecting roads. Then I spatial joined them back to the original dataset.

I tried using split function and it worked but in some cases (row 2) where the road names have a third or fourth name- this solution doesn't work.

What I would like is for the 2nd row to have:

BegLocation_New equal Chapala St

EndLocation_New equal State St

I was thinking I could wildcard query the field that has more than one '&' delimiter and remove text before it?

Looking for solution in python or arcade within the field calculator.

OR if there is a model or some script starting from scratch I am open to that as well. Have found some solutions but many are either out dated or don't specifically offer what I am looking for.

Thanks for any feedback or input. Best Regards.

ChrisSpadi · Answer

That happened when I deleted identicals, where streets turn from E to W or S to N. It left those in.

kenbuja · Answer

You can cycle through the Split array items and discard the ones that equal the NAME_ALF value. The next problem would be picking the right one for your second row in this example. Why would it be State and not E Anapamu?

var street = 'Bath St';
var string = 'Chapala St & Bath St';
var arr = split(string, '&')
var output
for (var i in arr) {
    if (Trim(arr[i]) != street) return Trim(arr[i])
}

ChrisSpadi · Answer

I don't think this will work because I am realizing the BegLocation and EndLocation have the intersecting street name but they vary in placement in the string base off the original fc beg and end vertices.

Is there a way to use the NAME_ALF field to remove it from the BegLocation and EndLocation fields? That way the remaining string would in most cases be the intersection road names?