topic Re: how to remove comma in number in Getting Data In

how to remove comma in number

jip31 — Wed, 10 Feb 2021 16:06:30 GMT

I try to remove the comma in my number but it doesnt works

Could you help me please?

| rex field=count mode=sed "s/,/./g" | stats count(HOSTNAME)

Re: how to remove comma in number

richgalloway — Wed, 10 Feb 2021 16:35:21 GMT

The rex command is trying to modify a field that will be created/modified by the stats command which follows. Since the count function does not include commas there is no need to remove them.

If this does not solve the problem then please add more information to describe the problem. Include sample results.

Re: how to remove comma in number

jip31 — Thu, 11 Feb 2021 04:42:57 GMT

My number which is one thousand three hundred thirty is displayed like this : "1,330" and I want this : "1330"

Re: how to remove comma in number

saravanan90 — Thu, 11 Feb 2021 05:03:09 GMT

This may help..

| rex field=count mode=sed "s/,//g"

Re: how to remove comma in number

jip31 — Thu, 11 Feb 2021 08:11:40 GMT

like this?

| stats count(HOSTNAME) | rex field=count mode=sed "s/,//g"

it doesnt works

Re: how to remove comma in number

saravanan90 — Thu, 11 Feb 2021 08:31:35 GMT

we can use like below..

| stats count(HOSTNAME) | rex field=count(HOSTNAME) mode=sed "s/,//g"

Re: how to remove comma in number

ITWhisperer — Thu, 11 Feb 2021 10:47:01 GMT

In your simple xml, format the fields like this

<format type="number" field="count(HOSTNAME)"> <option name="precision">0</option> <option name="useThousandSeparators">false</option> </format>

Re: how to remove comma in number

jip31 — Thu, 11 Feb 2021 14:57:29 GMT

I have the message "Node <format> is not allowed here"

I put the xml like this :

</search> <option name="colorBy">value</option> <option name="colorMode">block</option> <option name="drilldown">none</option> <option name="numberPrecision">0</option> <option name="rangeColors">["0x53a051","0x53a051"]</option> <option name="rangeValues">[0]</option> <option name="refresh.display">progressbar</option> <option name="useColors">1</option> <format type="number" field="count"> <option name="precision">0</option> <option name="useThousandSeparators">false</option> </format> </single>

Re: how to remove comma in number

ITWhisperer — Thu, 11 Feb 2021 15:08:34 GMT

For single visualisations try:

<option name="useThousandSeparators">false</option>

Re: how to remove comma in number

jip31 — Thu, 11 Feb 2021 15:21:14 GMT

thanks it works now!!