topic Re: Calculate field inserting extra characters in ArcGIS Pro Questions

Calculate field inserting extra characters

JoeLivoti — Fri, 07 Aug 2020 14:59:24 GMT

I am trying to add a hyperlink to a layer referencing another field in the layer. I'm using python3 expression type in the calculate field window. Below is the code:

'https://s3.console.aws.amazon.com/s3/buckets/hamptondes/Manhole/!FACILITYID!'

However, It is populating with:

https://s3.console.aws.amazon.com/s3/buckets/hamptondes/Manhole/u"00133"

For some reason it is adding the u and the " " around my facility ID

I need it to simply be:

https://s3.console.aws.amazon.com/s3/buckets/hamptondes/Manhole/00133

Any help is greatly appreciated!

Re: Calculate field inserting extra characters

DanPatterson — Sun, 12 Dec 2021 07:03:54 GMT

If you need a string returned, then you need to concatenate the inputs as strings

r = r"https://s3.console.aws.amazon.com/s3/buckets/hamptondes/Manhole/"

f = "{}{}".format(r, "00133")

f
'https://s3.console.aws.amazon.com/s3/buckets/hamptondes/Manhole/00133'‍‍‍‍‍‍

if it is something else, the link is no good, copy the code here if possible.

Re: Calculate field inserting extra characters

JoshuaBixby — Fri, 07 Aug 2020 16:41:58 GMT

Try:

r"url=https://s3.console.aws.amazon.com/s3/buckets/hamptondes/Manhole/{}".format(!FACILITYID!)‍

Re: Calculate field inserting extra characters

JoeLivoti — Fri, 07 Aug 2020 16:47:42 GMT

Thank you both for your help! I used this in the field =

'https://s3.console.aws.amazon.com/s3/buckets/hamptondes/Manhole/{}'.format(!FACILITYID!)