https://community.splunk.com/t5/Splunk-Search/How-to-keep-the-number-on-the-right-side-after-changing-the/m-p/484224#M135525 <P>I am not aware of one.</P> Fri, 28 Feb 2020 18:20:45 GMT richgalloway 2020-02-28T18:20:45Z https://community.splunk.com/t5/Splunk-Search/How-to-keep-the-number-on-the-right-side-after-changing-the/m-p/484221#M135522 <P>Hello Splunker!</P> <P>I added the "tostring + commas" to a number to get the thousand separator. Work's fine.<BR /><BR /> The problem is when I do the rex command to replace the commas with a space to match the canadian format number, my numbers get shifted on the left side. Is there another way to do so, so I can keep my number on the right side? See code below:</P> <P>| eval sum_totrows=tostring(sum_totalrows,"commas")<BR /> | rex field=sum_totrows mode=sed "s/,/ /g"</P> <P>Result:<BR /> 407 930<BR /> 119<BR /> 14 131<BR /> ...</P> <P>Thanks!</P> Wed, 30 Sep 2020 04:25:57 GMT https://community.splunk.com/t5/Splunk-Search/How-to-keep-the-number-on-the-right-side-after-changing-the/m-p/484221#M135522 usernamejpblais 2020-09-30T04:25:57Z https://community.splunk.com/t5/Splunk-Search/How-to-keep-the-number-on-the-right-side-after-changing-the/m-p/484222#M135523 <P>There is justification setting in Splunk. Numbers are automatically right-justified and strings are left-justified (at least in the US locale). Putting spaces in numbers converts them to strings so that is why they are left-justified.</P> Fri, 28 Feb 2020 17:10:45 GMT https://community.splunk.com/t5/Splunk-Search/How-to-keep-the-number-on-the-right-side-after-changing-the/m-p/484222#M135523 richgalloway 2020-02-28T17:10:45Z https://community.splunk.com/t5/Splunk-Search/How-to-keep-the-number-on-the-right-side-after-changing-the/m-p/484223#M135524 <P>Ok I understand, so is there a way to configure the setting to change the thousand separator from commas to space?</P> Fri, 28 Feb 2020 17:39:50 GMT https://community.splunk.com/t5/Splunk-Search/How-to-keep-the-number-on-the-right-side-after-changing-the/m-p/484223#M135524 usernamejpblais 2020-02-28T17:39:50Z https://community.splunk.com/t5/Splunk-Search/How-to-keep-the-number-on-the-right-side-after-changing-the/m-p/484224#M135525 <P>I am not aware of one.</P> Fri, 28 Feb 2020 18:20:45 GMT https://community.splunk.com/t5/Splunk-Search/How-to-keep-the-number-on-the-right-side-after-changing-the/m-p/484224#M135525 richgalloway 2020-02-28T18:20:45Z https://community.splunk.com/t5/Splunk-Search/How-to-keep-the-number-on-the-right-side-after-changing-the/m-p/484225#M135526 <P><A href="https://www.btb.termiumplus.gc.ca/tcdnstyl-chap?lang=eng&amp;lettr=chapsect5&amp;info0=5">Canadian style</A><BR /> that's interesting</P> <P><CODE>| eval sum_totrows=replace(tostring(sum_totalrows,"commas"),","," ")</CODE><BR /> one liner.</P> Fri, 28 Feb 2020 18:39:33 GMT https://community.splunk.com/t5/Splunk-Search/How-to-keep-the-number-on-the-right-side-after-changing-the/m-p/484225#M135526 to4kawa 2020-02-28T18:39:33Z https://community.splunk.com/t5/Splunk-Search/How-to-keep-the-number-on-the-right-side-after-changing-the/m-p/484226#M135527 <P>I like that one liner but I have the same problem, number shift to the left. </P> Fri, 28 Feb 2020 18:51:24 GMT https://community.splunk.com/t5/Splunk-Search/How-to-keep-the-number-on-the-right-side-after-changing-the/m-p/484226#M135527 usernamejpblais 2020-02-28T18:51:24Z https://community.splunk.com/t5/Splunk-Search/How-to-keep-the-number-on-the-right-side-after-changing-the/m-p/484227#M135528 <P>That's exactly what @richgalloway says. <BR /> Creating dashboard can use js and css, maybe we can.<BR /> but I don't know. ask another experts.</P> Fri, 28 Feb 2020 19:35:07 GMT https://community.splunk.com/t5/Splunk-Search/How-to-keep-the-number-on-the-right-side-after-changing-the/m-p/484227#M135528 to4kawa 2020-02-28T19:35:07Z