Skip to main content
Question

FME Desktop 2022: How to add comma separator (thousands separator) and specify the number of decimal places?

  • February 28, 2022
  • 4 replies
  • 364 views

jamal
Forum|alt.badge.img+5

FME Desktop 2022: How to add comma separator (thousands separator) and specify the number of decimal places?

 

I couldn’t figure out how to add comma separator (thousands separator) and specify the number of decimal places as they appear in the table

 

Clip_139Clip_140 

 

 

 

 

4 replies

redgeographics
Celebrity
Forum|alt.badge.img+49

Neither of those can be set in the Table View. I can see the thousands separator to be a useful option so I would urge you to create an idea for that (if there isn't one already). I'm not too sure about rounding decimals though, you want to use FME for inspecting the data as it is, not as it is interpreted (but that's my personal opinion).

 

A workaround for the decimals would be to use an AttributeRounder before inspecting, but this will change the attribute values.


Forum|alt.badge.img+2
  • February 28, 2022

@jamal​ FME Data Inspector is designed as a quick view application. we'd generally recommend changing the display styles/formatting in the target format, such as Excel


mark2atsafe
Safer
Forum|alt.badge.img+44

There is a NumberSeparator transformer that you could use to do that. But be aware that it changes the content of the attribute, so you are then dealing with a string - not a number - and could not do arithmetic calculations on it.


jamal
Forum|alt.badge.img+5
  • Author
  • March 8, 2022

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings