Splunk Search
Highlighted

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

Communicator

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.

0 Karma
Highlighted

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

SplunkTrust
SplunkTrust

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.

---
If this reply helps you, an upvote would be appreciated.

View solution in original post

0 Karma