Hyperlink Field — Replace spaces with URL-encoded value “%20”

Bud — Wed, 27 Sep 2023 19:37:14 GMT

Oracle 18c 10.7.1 EGDB:

This isn't my area of expertise; I'm posting this idea because it's an issue my organization dealt with recently. I'll try to explain it as well as I can.

I have a FC that has a FILE_URL field. The values in the field are URLs to on-prem files, such as:

http://a.b.c.on.local/DRAWINGS/A123.PDF
http://a.b.c.on.local/DRAWINGS/B 123.PDF

Identify tool:

In a web map, when using the identify tool, URL #1 works as a clickable hyperlink because the file name doesn't have spaces. But URL #2 is not a clickable hyperlink, it's just plain text because the file name has a space.

Attribute Table widget:

Additionally, while URL #2 is technically a hyperlink in the Attribute Table widget, the hyperlink is broken/incorrect: http://a.b.c.on.local/DRAWINGS/B 123.PDF. The hyperlink incorrectly excludes the portion of the URL that comes after the space in the hyperlink.

We can workaround the identify window issue by using an Attribute Expression (Arcade) to replace spaces with “%20”:

return Replace($feature["FILE_URL"]," ","%20")

However, that expression doesn't get applied in the Attribute Table, so the Attribute Table hyperlink is still broken.

We might have the option to work around this issue in the underlying data (by replacing spaces with “%20” in a field):

Use a calculation attribute rule to populate an additional field in the FC
Or use a calculated SQL field in a database view (note: layers based on database views are read-only/uneditable)

However, those workarounds add unwanted complexity.

Idea:

Could OOTB functionality be added to the web map that automatically replaces spaces in the URL with the encoded value “%20” ? That would be the cleanest way of ensuring URLs with spaces work correctly as hyperlinks in web maps.

Re: Hyperlink Field — Replace spaces with URL-encoded value “%20” - Status changed to: Needs Clarification

SSWoodward — Wed, 27 Sep 2023 18:22:27 GMT

@Bud so I can fully understand. The FILE_URL field, is a plain text field in your feature class?

Re: Hyperlink Field — Replace spaces with URL-encoded value “%20”

Bud — Wed, 27 Sep 2023 18:51:58 GMT

@SSWoodward Yes.

Re: Hyperlink Field — Replace spaces with URL-encoded value “%20” - Status changed to: Open

SSWoodward — Wed, 27 Sep 2023 20:26:10 GMT

idea Hyperlink Field — Replace spaces with URL-encoded value “%20” in ArcGIS Enterprise Ideas

Hyperlink Field — Replace spaces with URL-encoded value “%20”

Re: Hyperlink Field — Replace spaces with URL-encoded value “%20” - Status changed to: Needs Clarification

Re: Hyperlink Field — Replace spaces with URL-encoded value “%20”

Re: Hyperlink Field — Replace spaces with URL-encoded value “%20” - Status changed to: Open