https://community.splunk.com/t5/Splunk-Search/What-is-the-most-elegant-way-to-convert-from-float-to-currency/m-p/483392#M193330 <P>Miraculously in 2020 there still hasn't been a Splunk Answer that details an elegant way to convert from float to currency.</P> <P>Is this the best possible solution, or are there more elegant ways to do this? Careful of negative numbers.</P> <P><CODE>eval budget_amount="$".tostring(budget_amount,"commas") | rex mode=sed field=budget_amount "s/\$$-/-$$/g"</CODE> </P> Wed, 26 Feb 2020 23:29:51 GMT nick405060 2020-02-26T23:29:51Z https://community.splunk.com/t5/Splunk-Search/What-is-the-most-elegant-way-to-convert-from-float-to-currency/m-p/483392#M193330 <P>Miraculously in 2020 there still hasn't been a Splunk Answer that details an elegant way to convert from float to currency.</P> <P>Is this the best possible solution, or are there more elegant ways to do this? Careful of negative numbers.</P> <P><CODE>eval budget_amount="$".tostring(budget_amount,"commas") | rex mode=sed field=budget_amount "s/\$$-/-$$/g"</CODE> </P> Wed, 26 Feb 2020 23:29:51 GMT https://community.splunk.com/t5/Splunk-Search/What-is-the-most-elegant-way-to-convert-from-float-to-currency/m-p/483392#M193330 nick405060 2020-02-26T23:29:51Z https://community.splunk.com/t5/Splunk-Search/What-is-the-most-elegant-way-to-convert-from-float-to-currency/m-p/483393#M193331 <P>How about:</P> <PRE><CODE>|eval budget_amount=if(budget_amount&gt;=0,"$".tostring(budget_amount,"commas"), "-$".tostring(abs(budget_amount),"commas")) </CODE></PRE> Thu, 27 Feb 2020 15:21:53 GMT https://community.splunk.com/t5/Splunk-Search/What-is-the-most-elegant-way-to-convert-from-float-to-currency/m-p/483393#M193331 spayneort 2020-02-27T15:21:53Z