Replicating 'Field Delimiter' functionality in ArcMap symbology within ArcGIS Pro 2.4.3

01-23-2020 11:36 AM
New Contributor III

I need to list "Park Names(string)" within my legend and have them sorted by their "Park Number(int)". I do this in ArcMap 10.5 by going to Properties->Symbology->Unique values, many fields->Place "Park Number" in slot 1 and "Park Name" in slot 2->Advanced->Field Delimiter-> Replace "," with ". "->Ok->Apply

In ArcGIS Pro I can do the same thing, up until designating a new delimiter. I cannot figure out how to switch it from a comma to anything else.

I have tried using Arcade to build a label expression but it casts the entire label as a string, and thus sorts the parks based on number strings.

Worst case scenario I type it all up manually, but I'm hoping there's something I have overlooked.

Thank you

6 Replies
Esri Esteemed Contributor

Hi Cherokee_CO_GIS ,

I suppose that formatting the number in Arcade with preceding ceros could be an option, but I don't know if that is something you are willing to accept. But, I also did not find an option to define the delimiter.

Kory Kramer‌; is that coming in 2.5?

Esri Community Moderator

Hi Xander - no I don't see this in 2.5.  Custom field delimiter in ArcGIS Pro indicates that their use case was resolved with the Arcade capabilities in Pro.  For this current use case of needing to sort, would it be possible to use the Arcade Sort function to make it work?  (Even if so, writing custom code to achieve this without a UI is an issue.  I'll check with the team on this one...)

New Contributor III

I will look into sorting with Arcade, and start ranging out a little bit more to explore my options.

Thank you for responding so quickly.

0 Kudos
New Contributor III

Hi Kory, the link you provided isn't working for me. I am looking to modify the field delimiter from "," to " - ". I am not concerned about modifying the sorting parameters for this one. How can I do this in ArcGIS Pro 2.7?



0 Kudos
Esri Contributor

Interesting, that's not what the field delimiter was designed for!

Backstory: In ArcMap when creating unique value symbology from many fields, we typically store "<value 1>,<value2>" etc with each value being separated by a comma. This approach worked for many cases, but went horribly wrong when the unique value from a field actually contained a comma. We added analysis code to detect this when generating unique values and would switch the separator to another character. The UI under Advanced was just there to provide an annotation place to edit it.

In ArcGIS Pro, we don't store unique values for the comma delimited case in a single string with a separator. We store an array of values. Therefore, we don't need the delimiter for the above purpose. Obviously you can hand edit the labels for the classes to not be commas, but I can imagine that would be time consuming as you note. It appears the sort is primarily an issue for 1-9 and then things are ok after that, so maybe re-ordering just those won't be too bad. Looks like we have a few things to look into including the sort.

Esri Community Moderator

Nathanial Story‌ for the drag-drop functionality, note that in ArcGIS Pro 2.5 (which should be available February 6th) you'll be able to select multiple classes and move them at the same time.  See ArcGIS Pro UI symbology improvement 

Here is the TRICK.  Once you have the classes selected, hold the SHIFT key to drag the multiple classes at the same time.  If you don't hold SHIFT, the picker thinks you just want a single class again.  

Hope this helps.