topic Re: curly brackets in GUID in ArcGIS Pro Questions

curly brackets in GUID

DanielSørensen — Sat, 22 Feb 2020 16:00:53 GMT

Hi,

When importing data from a PostgreSQL database into ArcGIS Pro, the UUID from PostgreSQL are transformed into GUIDs, and for some reason the GUID contains curly brackets in the begnning and end, as showend below:

Do you guys know how to avoid that? Or, how to remove the curly brackets?

Re: curly brackets in GUID

DavidPike — Sun, 12 Dec 2021 04:59:33 GMT

Hi, completely unsure of the reason but a quick fix in field calculator would be:

set it to python on the radio button and click 'show codeblock' put this in the pre-logic script code :

def curly(field):
    field = field.replace("{","")
    field = field.replace("}","")
    return field‍‍‍‍

then type into the codeblock at the bottom (below 'my field =')

curly(the name of your field enclosed within ! !)

e.g.

curly(!GUID!)

Re: curly brackets in GUID

JoshuaBixby — Sun, 23 Feb 2020 01:42:01 GMT

The most important statement you made is, "when importing..." I am guessing your field type in Pro will show as GUID. If so, you can't just remove the curly brackets. How are you importing the data?

Re: curly brackets in GUID

DanielSørensen — Sun, 23 Feb 2020 09:19:00 GMT

Hi, I add data as a query layer and export features into a geodatabase, and yes, the field type in Pro are showing GUID. Maybe this field type, will always include curly brackets?

Re: curly brackets in GUID

DanPatterson_Retired — Sun, 23 Feb 2020 10:48:26 GMT

perhaps the opening paragraphs here might explain why the field appears to change

ArcGIS field data types—Geodatabases | Documentation

and the section on Global Identifier section.