topic Re: Concatenate a URL followed by a Field Name Using Calculate Field in Data Management Questions

Concatenate a URL followed by a Field Name Using Calculate Field

SarojThapa1 — Mon, 21 Aug 2017 15:49:31 GMT

I am trying to concatenate a domain URL followed by a field name using Calculate Field tool. In the Expression field in the Calculate Field window, the sql expression looks like:

PHOTO_URL =

<a href=DomainURL/FolderName/&" "&!PHOTO!>Photo</a>

However, in the attribute table, the PHOTO_URL's values are populated as

<a href=''DomainURL/FolderName/PhotoName.jpg''''>Photo</a>

I get an extra " at the end of the href. When opening the map service using the arcgis online, when the PHOTO_URL atttribute is clicked, it reloads the current web URL instead of redirecting to the photo url.

Any help or suggestions are greatly appreciated.

Thanks

Re: Concatenate a URL followed by a Field Name Using Calculate Field

shan_sarkar — Tue, 22 Aug 2017 05:07:25 GMT

Saroj,

Can you share one record from your data so that I can test the issue?

~Shan

Re: Concatenate a URL followed by a Field Name Using Calculate Field

DanPatterson_Retired — Sat, 11 Dec 2021 23:22:29 GMT

python syntax

PHOTO = 'somephoto.jpg'
'DomainURL/FolderName/{}'.format(PHOTO)  # syntax line‍‍‍‍‍‍

yields

'DomainURL/FolderName/somephoto.jpg'‍

Field calculator syntax

'DomainURL/FolderName/{}'.format(!PHOTO!)  # syntax line‍‍‍‍‍

just put exclamation marks around PHOTO in the syntax line above so that it reads ... !PHOTO!

Re: Concatenate a URL followed by a Field Name Using Calculate Field

SarojThapa1 — Tue, 22 Aug 2017 15:12:14 GMT

Thanks for your response, Shantonu. The issue is resolved now.