https://community.splunk.com/t5/Splunk-Search/tostring-commas-and-locale-specific-separators/m-p/80566#M181830 <P>My browser settings ? Just checked on both Safari (Mac OS X) and Chrome and nothing like that it's there ...</P> <P>Any pointers ?</P> Thu, 22 Mar 2012 16:18:40 GMT arturo 2012-03-22T16:18:40Z https://community.splunk.com/t5/Splunk-Search/tostring-commas-and-locale-specific-separators/m-p/80561#M181825 <P>My question is whether or not the tostring command is locale specific. If the locale specifies commas as the decimal and periods as the separator will tostring do the the right thing? </P> <P>It might better if the option was tostring(<FIELDNAME>, "separators").</FIELDNAME></P> Tue, 28 Feb 2012 16:23:54 GMT https://community.splunk.com/t5/Splunk-Search/tostring-commas-and-locale-specific-separators/m-p/80561#M181825 colinj 2012-02-28T16:23:54Z https://community.splunk.com/t5/Splunk-Search/tostring-commas-and-locale-specific-separators/m-p/80562#M181826 <P>Yes, it might be better. But the "commas" operator is locale specific.</P> <P>[Update] I am wrong. After believing this for a long time, I was chagrined to find that it is untrue. The <CODE>commas</CODE> operator of the <CODE>tostring</CODE> command inserts commas. Always.</P> <P>@sowings has a solution:</P> <PRE><CODE>searchstring | stats count | eval count=tostring(count,"commas:) | rex field=count mode=sed "s/,/./g" </CODE></PRE> Tue, 28 Feb 2012 16:33:12 GMT https://community.splunk.com/t5/Splunk-Search/tostring-commas-and-locale-specific-separators/m-p/80562#M181826 lguinn2 2012-02-28T16:33:12Z https://community.splunk.com/t5/Splunk-Search/tostring-commas-and-locale-specific-separators/m-p/80563#M181827 <P>So the "commas" operator will do the right thing?</P> Thu, 15 Mar 2012 21:37:39 GMT https://community.splunk.com/t5/Splunk-Search/tostring-commas-and-locale-specific-separators/m-p/80563#M181827 colinj 2012-03-15T21:37:39Z https://community.splunk.com/t5/Splunk-Search/tostring-commas-and-locale-specific-separators/m-p/80564#M181828 <P>Where can I configure "commas" as "locale specific" ??</P> Fri, 16 Mar 2012 16:23:51 GMT https://community.splunk.com/t5/Splunk-Search/tostring-commas-and-locale-specific-separators/m-p/80564#M181828 arturo 2012-03-16T16:23:51Z https://community.splunk.com/t5/Splunk-Search/tostring-commas-and-locale-specific-separators/m-p/80565#M181829 <P>It's based on your browser settings.</P> Fri, 16 Mar 2012 20:04:30 GMT https://community.splunk.com/t5/Splunk-Search/tostring-commas-and-locale-specific-separators/m-p/80565#M181829 lguinn2 2012-03-16T20:04:30Z https://community.splunk.com/t5/Splunk-Search/tostring-commas-and-locale-specific-separators/m-p/80566#M181830 <P>My browser settings ? Just checked on both Safari (Mac OS X) and Chrome and nothing like that it's there ...</P> <P>Any pointers ?</P> Thu, 22 Mar 2012 16:18:40 GMT https://community.splunk.com/t5/Splunk-Search/tostring-commas-and-locale-specific-separators/m-p/80566#M181830 arturo 2012-03-22T16:18:40Z https://community.splunk.com/t5/Splunk-Search/tostring-commas-and-locale-specific-separators/m-p/80567#M181831 <P>Does not seem to be in my Swiss German settings</P> Wed, 12 Jun 2013 12:20:33 GMT https://community.splunk.com/t5/Splunk-Search/tostring-commas-and-locale-specific-separators/m-p/80567#M181831 mplungjan 2013-06-12T12:20:33Z https://community.splunk.com/t5/Splunk-Search/tostring-commas-and-locale-specific-separators/m-p/80568#M181832 <P><A href="http://splunk-base.splunk.com/answers/10265/change-default-web-ui-locale">http://splunk-base.splunk.com/answers/10265/change-default-web-ui-locale</A></P> Wed, 12 Jun 2013 12:44:32 GMT https://community.splunk.com/t5/Splunk-Search/tostring-commas-and-locale-specific-separators/m-p/80568#M181832 mplungjan 2013-06-12T12:44:32Z https://community.splunk.com/t5/Splunk-Search/tostring-commas-and-locale-specific-separators/m-p/80569#M181833 <P>And my apologies for not coming back to this answer and fixing it sooner.</P> Tue, 24 May 2016 17:42:26 GMT https://community.splunk.com/t5/Splunk-Search/tostring-commas-and-locale-specific-separators/m-p/80569#M181833 lguinn2 2016-05-24T17:42:26Z https://community.splunk.com/t5/Splunk-Search/tostring-commas-and-locale-specific-separators/m-p/80570#M181834 <P>Actually that isn't complete. This would show 1234.56 as 1.234.56 when it is expected to see 1.234,56<BR /> Add an extra 2 lines to fix it.</P> <PRE><CODE>| eval count=tostring(count,"commas") | rex field=count mode=sed "s/\./#/g" | rex field=count mode=sed "s/,/./g" | rex field=count mode=sed "s/#/,/g" </CODE></PRE> <P>make it into a macro if you need it a lot.</P> Wed, 14 Sep 2016 15:21:14 GMT https://community.splunk.com/t5/Splunk-Search/tostring-commas-and-locale-specific-separators/m-p/80570#M181834 bmunson_splunk 2016-09-14T15:21:14Z