topic Re: Having a space as the thousands separator, and be able to order when you click on the column in Splunk Enterprise

Having a space as the thousands separator, and be able to order when you click on the column

alvesri — Fri, 22 Mar 2024 18:44:49 GMT

Hi guys can you please help me ?

I'm trying to use a space as thousands separator and I can't, the max that I could it's a comma with this:

eval value= if(value!="N/A",printf("%'d",value),value)

Result = 123,456

so I guess I can change it with a replace maybe,

But then we have problem number 2 ,

When I try to sort the by value in the arrow of the column, the sort it isn't correct, and the bigger numbers are considerate as strings.

Can you guys help me solve this please ?

Tell me if you need more things

Re: Having a space as the thousands separator, and be able to order when you click on the column

isoutamo — Fri, 22 Mar 2024 17:58:34 GMT

you should look

fieldformat
tostring(var,”commas”)

which fulfills your requirement.

r. Ismo

Re: Having a space as the thousands separator, and be able to order when you click on the column

alvesri — Mon, 25 Mar 2024 09:38:38 GMT

Hi thank you for the reply,

I tried that, and it works replacing the comma with a space, but the issue it's next when i click on the column to sort in a descending order, and the numbers are not sorted correctly, because some of them are string and others are numbers, and I tried the conversion "tonumber()"

Re: Having a space as the thousands separator, and be able to order when you click on the column

ITWhisperer — Mon, 25 Mar 2024 09:49:34 GMT

| fieldformat value=replace(tostring(value,"commas"),","," ")

Re: Having a space as the thousands separator, and be able to order when you click on the column

alvesri — Mon, 25 Mar 2024 10:27:31 GMT

Hi guys,

I did this ant it worked in replacing the comma, thank you.
The N/A is in case i'ts empty.

| eval value= if(value!="N/A", replace(tostring(value,"commas"),","," "),value)

But the thing is, I can't order it correctly.

Re: Having a space as the thousands separator, and be able to order when you click on the column

isoutamo — Mon, 25 Mar 2024 12:15:35 GMT

Fieldformat is just to keep those values as numbers instead of covert those to string as happened with eval.