topic Re: Reassign display text in table using advanced formatting (remove underscores) in ArcGIS Dashboards Questions

Reassign display text in table using advanced formatting (remove underscores)

dwold — Fri, 16 Feb 2024 15:09:58 GMT

I would like to change the display text in a table. Currently, my values have underscores. I would like to remove those underscores so it is cleaner on the table. I am new to arcade but I believe I need to assign a variable and change the text values there and then call that variable in the displayText line?

@JenniferAcunto

@IssyAmis

@AdrianWelsh

Re: Reassign display text in table using advanced formatting (remove underscores)

AdrianWelsh — Fri, 16 Feb 2024 15:25:52 GMT

I have used the Replace function in Arcade to replace my underscores for spaces (at least in a popup window). I think it should work for a table too. Here is an example:

https://support.esri.com/en-us/knowledge-base/how-to-replace-values-of-a-field-using-an-arcade-expres-000022951

And this is the developer site for the function itself: https://developers.arcgis.com/arcade/function-reference/text_functions/#replace

Re: Reassign display text in table using advanced formatting (remove underscores)

JenniferAcunto — Fri, 16 Feb 2024 15:30:52 GMT

Yes. You are on the right track. You will want to use the Replace function to search for _ and replace it with a space.

var prettytext = Replace($datapoint.core_capability, '_', ' ')

In the below example, my data has commas instead of an underscore, but the basic principle is the same.

Re: Reassign display text in table using advanced formatting (remove underscores)

dwold — Fri, 16 Feb 2024 18:52:16 GMT

@JenniferAcunto thank you!!!!

Re: Reassign display text in table using advanced formatting (remove underscores)

dwold — Fri, 16 Feb 2024 18:52:37 GMT

@AdrianWelsh thanks for the tip!!