Latest Contributions by JeffThomasILM

I cannot vote this up enough. I hate every open/export/save interface in Pro; I cannot understand why it doesn't default to the project's home folder, nor have a home button like ArcMap.  ... View more

It does allow you to edit any content if you're an admin, but you have to search for something. It doesn't just list everything like it does for your own content. I see your comment is from a year ago; perhaps this functionality has been added since then. On the dropdown menu to the right of the search box, select your org, then type something in. It will give you all results regardless of owner. It's not a total solution if you want to browse all your org's content, but it's better than nothing. ... View more

I want to like Arcade, and its use is mandatory for many newer functions of Pro and AGOL, but... it's a young language. There will be bumps. Thank you again for your help, Xander Bakker! ... View more

Xander Bakker, You're the #1 answerer of my questions on GeoNet. Thank you! You went ahead and created a for loop like I theorized, but would have taken me a long time to figure out! Indeed, it does work. I'm left shaking my head once again at the verbosity of Arcade vs. Python. But, you did concede that it's probably not the best or fastest way. Though I really appreciate the speed of your reply! ... View more

I'd love to hear some feedback from Esri. This shouldn't even need to be an "idea" - it's important functionality from ArcMap missing from Pro! Editing nonversioned data is explicitly not possible unless you change a setting. ... View more

Ah! I figured it out. When you copied my expression into the playground, you unwittingly, but correctly, added braces around the for loop. I failed to notice previously that every label was showing only the last word of the name; I was only paying attention to the Mac names. After adding the braces, many more street names magically popped into the map! Thanks! For posterity, here's the corrected expression: if (!IsEmpty($feature.STREET)) { var words = split(upper($feature.STREET), " ") var Mac = ["MACCUMBER", "MACKAY", "MACKENZIE", "MACMILLAN", "MACRAE"] var dir = proper(DomainName($feature, 'DIR')) var street = "" var type = proper(DomainName($feature, 'TYPE')) for (var i in words) { var isMac = indexof(Mac, words[i]) > -1 if (left(words[i], 2) == "MC") { street += upper(words[i][0]) + lower(words[i][1]) + upper(words[i][2]) + lower(right(words[i], count(words[i]) - 3)) + " "; } else if (isMac) { street += upper(words[i][0]) + lower(words[i][1]) + lower(words[i][2]) + upper(words[i][3]) + lower(right(words[i], count(words[i]) - 4)) + " "; } else { street += iif(IsNan(number(words[i][0])), proper(words[i]), lower(words[i])) + " "; } } return concatenate([dir, street, type]," "); } else { return ""; }‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

I discovered there are also some "Mac" street names to consider, too. The problem is, "Mac" can't be called out universally like "Mc", so I have to have a whitelist of "Mac" names to consider. I am now using every bit of new Arcade logic that I've learned from Ciara on this thread. I got it to work with most of the Mac names I have, except one problem: it doesn't work if "Mac" is preceded by another word, e.g. "Old MacCumber Station". The resulting label is just "Station". I'm afraid I've tapped out my Arcade knowledge... do you know what I need to change for it to work properly? Thank you! if (!IsEmpty($feature.STREET)) { var words = split($feature.STREET, " ") var Mac = ["MACCUMBER", "MACKAY", "MACKENZIE", "MACMILLAN", "MACRAE"] var dir = proper(DomainName($feature, 'DIR')) var street = "" var type = proper(DomainName($feature, 'TYPE')) for (var i in words) var isMac = indexof(Mac, words[i]) > -1 if (left(words[i], 2) == "MC") { street += upper(words[i][0]) + lower(words[i][1]) + upper(words[i][2]) + lower(right(words[i], count(words[i]) - 3)) + " "; } else if (isMac) { street += upper(words[i][0]) + lower(words[i][1]) + lower(words[i][2]) + upper(words[i][3]) + lower(right(words[i], count(words[i]) - 4)) + " "; } else { street += iif(IsNan(number(words[i][0])), proper(words[i]), lower(words[i])) + " "; } return concatenate([dir, street, type]," "); } else { return ""; }‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ Side note to the Esri community webmaster: shouldn't Arcade be added to the the code block language options? ... View more

Here's the code I'm currently using, in case it's helpful to anyone. There are many nulls and blanks in our street names (I have no control over them) so I have to filter those out first (as covered in this thread), as well as concatenate the other pieces of the street name. I added one special condition to look for, "Mc", and could add more using this if-else logic if needed. Fortunately, I don't have many street names needing special formatting like Ciara mentioned. if (!IsEmpty($feature.STREET)) { var words = split($feature.STREET, " ") var dir = proper(DomainName($feature, 'DIR')) var street = "" var type = proper(DomainName($feature, 'TYPE')) for (var i in words) if (left(words[i], 2) == "MC") { street += upper(words[i][0]) + lower(words[i][1]) + upper(words[i][2]) + lower(right(words[i], count(words[i]) - 3)) + " "; } else { street += iif(IsNan(number(words[i][0])), proper(words[i]), lower(words[i])) + " "; } return concatenate([dir, street, type]," "); } else { return ""; }‍‍‍‍‍‍‍‍‍‍‍‍‍‍ Thanks again to Kory and Ciara. ... View more

Thank you, Ciara. I know there's no one perfect solution, but you're giving exactly what I had hoped for: examples of how to apply similar methods/logic of Python in Arcade.  ... View more

Sorry for being a bit insensitive above; I'm very appreciative of all the help I've received here on GeoNet. I am always trying to cobble together solutions with my limited knowledge of Python and now Arcade. I get exasperated with the transition occasionally. I imagine Ciara's expression would in fact work as intended with a tweak or two. But the bigger issue is that I suspect Arcade simply doesn't have methods equivalent to Python's for this problem (yet). That makes sense; Python's been around many years and Arcade is still pretty new. Seeing as Arcade is entirely under Esri's control, there are many map-specific issues that should be incorporated into Arcade. For instance, wouldn't it be nice if Proper() simply handled case properly including ordinals? Is there some reason that would be undesirable or unworkable? Thanks. ... View more

Thanks for the video link; that heads me in the right direction. However, it doesn't totally fix the problem. Her example explicitly lists out 1ST, 2ND, etc. rather than a regex or some Arcade equivalent to Python's isalpha, capitalize, or capwords methods that handle any ordinals. I wondered if it would work on two or more digit ordinals and I verified it doesn't with my own data. I thought maybe I made a typo when copying her function, but I even went back and watched the video again to see if any two-digit ordinal streets are visible: Yep, and indeed the case wasn't fixed in her own example (see "12Th" below). I laughed a little when she said, "I can write quite a simple expression to fix that." It's 10 times longer than the Python solution, which actually handles any ordinal! Surely there's a better way to do this with Arcade? ... View more