how to remove comma in number

[jip31]

hi

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)

[saravanan90]

This may help..

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

[jip31]

like this?

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

it doesnt works

[saravanan90]

we can use like below..

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

[richgalloway]

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.

[jip31]

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

[ITWhisperer]

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>

[jip31]

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>

[ITWhisperer · Accepted solution]

For single visualisations try:

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

[jip31]

thanks it works now!!