Skip to main content
Question

How do I format attributes in the attribute manager?

  • June 2, 2016
  • 2 replies
  • 161 views
N

I am just learning to use FME and have run into my first issue. I removed a value ({}) using the TrimRight and TrimLeft (

@TrimRight(@TrimLeft(@Value(GLOBALID),"{"),"}")

in the attribute manager but now I need to add those values back in so I can load the data into a database. This is what I did and no such luck.

@Format("{",@Value(SERVICELOCATIONGUID),"}") Any help would be welcomed.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

takashi
Celebrity
  • takashiCelebrity
  • June 2, 2016

Hi @natashalaw, you don't need to use any string function. Just concatenate {, the attribute value, and } in the field.

{@Value(SERVICELOCATIONGUID)}
Why not inspect features with Visual/Data Preview and Feature/Record Information before writing them into a destination dataset?
takashi
Celebrity
  • takashiCelebrity
  • June 2, 2016

Hi @natashalaw, you don't need to use any string function. Just concatenate {, the attribute value, and } in the field.

{@Value(SERVICELOCATIONGUID)}

Addition. Regarding trimming, you can also use the @Trim function.

@Trim(@Value(GLOBALID),{}) 
Why not inspect features with Visual/Data Preview and Feature/Record Information before writing them into a destination dataset?

Community Stats

32,207
Posts
122,303
Replies
39,891
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.