Skip to main content
  • EN

I am using FME(R) 2022.1.3.0 (20220928 - Build 22630)

I noticed while working with ArcGIS Data (FileGeodatabase), that when I use
the “DatabaseJoiner” Transformer to join attributes with curly brackets inside its values, the curly brackets are gone after joining. 
e.g. Original Attribute value: {12C300A2-64C3-4494-A1E2-430CC5C5C7A9}
joined value by DatabaseJoiner: 12C300A2-64C3-4494-A1E2-430CC5C5C7A9

It this a known behaviour? Why would it get rid of the curly brackets? 
Anything to do against it?

I just tried in 2023.1 and its retaining the curly brackets. Two things I can think of

  1. It was a bug that has been fixed
  2. I put the GUID in a text field, the behavior might be different if it is a GlobalID/GUID type?

To rectify it, you can use the StringConcatenator to add the opening and closing squiggly brackets

Thanks for your reply.
Yes, I fixed it using the StringConcatenator, but I found it a weird behaviour.
Yes, the source attribute is a GlobalID datatype, maybe it behaves differently.
At the moment I cannot try a newer version of FME, because newer versions removed
the “old” SQLIte (Spatial) writer completely and I am still quite depending on that.
Thanks again for testing this out,

Reply


Community Stats

30,108
Posts
114,295
Replies
37,744
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.