How to replace commas with dots to match Brazilian currency format?

[guimilare]

Hi all,

When searching for total price, I get the following answer:

...| stats sum(total_price) as "Valor Total"
| fieldformat "Valor Total" = "R$ " + tostring('Valor Total', "commas")

Answer: R$ 56,510.20

However, in Brazil, we use: R$ 56.510,00
How should I write my search?

Thanks in advance.

[richgalloway · Accepted solution]

The UI Internationalization section of the Developer manual (http://docs.splunk.com/Documentation/Splunk/6.2.4/AdvancedDev/TranslateSplunk) may be useful in telling Splunk how to format numbers in Brazil. Then you should not have to change your search.