Community
Select to view content in your preferred language

ArcMap equivalency - custom field delimiter for 'unique values, many fields'

409
2
10-13-2023 07:14 AM
Status: Open
Labels (1)
Labels
wayfaringrob
by
Honored Contributor

This solution proposes using Arcade for what I'm asking for, but Arcade has a learning curve and I'd rather not have to teach Arcade in my introductory class. It'd also just be easier for the everyday user. Per that question post, this is actually super simple in ArcMap (in fact, ArcMap uses comma and a space by default, which is much better looking than what pro does (just a comma).

So, the idea is for Pro to do what ArcMap does - provide an easy option for switching your delimiter without having to use Arcade. I'm basically just giving my students the Arcade code in the meantime but it shouldn't need to be that tricky - "do it this way if you're OK with just a comma, but do it this entirely different and more complicated way if you want something only marginally different." The Arcade builder doesn't give any pointers or for how to concatenate or clickable buttons for doing so, so it's not intuitive, either.

Default comma and space in ArcMap:

rburke_0-1697206375811.png

Easy peasy custom delimiter in ArcMap:

rburke_1-1697206394456.png

Default comma only delimiter in Pro, no option to customize:

rburke_2-1697206427557.png

Much less intuitive interface for adding custom delimiter in Pro:

rburke_3-1697206453298.png

 

2 Comments
jcarlson
by MVP Esteemed Contributor
‎10-13-2023 08:08 AM

Arcade's not too hard to figure out, but maybe a bit much to tack on to an intro class.

I agree wholeheartedly that the built in Arcade editor in Pro is next to useless. It's especially hard to use knowing how useful and slick the online expression editors have gotten.

wayfaringrob
by
‎10-13-2023 08:35 AM

@jcarlsonI agree, and some of them are figuring it out on their own; we use a dash of it here and there, but before, the instructions for this exact example could be quite simple, no code needed. All of the assignments I use were written for ArcMap and I keep finding things like this (usually involving expressions) that require way more explaining to figure it out in Pro.

Now, even if I conceded that we should teach a little code here and there, expression builders in pro are all over the place, ranging from no help (ex. field script in network analyst cost evaluators) to useless help (SQL mode almost everywhere). ArcMap's expression builders are solid and intuitive. Pro's are terrible for learning and frustrating in practice.

Improve SQL Expression Builder - Esri Community