Skip to main content

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.

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

{@Value(SERVICELOCATIONGUID)}

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),{}) 

Reply