format number with comma separators?

[Chris Morris]

I'm brain dead and just trying to get formatted numbers in a task that's
already 10 tangents deep -- argh. Anyway, how can I sprintf (or
otherwise) this:

456778904

to this:

456,778,904

--

Chris
[url]http://clabs.org/blogki[/url]

[Mark J. Reed]

On Tue, Aug 05, 2003 at 11:55:12PM +0900, Chris Morris wrote:

> I'm brain dead and just trying to get formatted numbers in a task that's
> already 10 tangents deep -- argh. Anyway, how can I sprintf (or
> otherwise) this:
>
> 456778904
>
> to this:
>
> 456,778,904

Unless there's something I don't know about - a distinct possibility
- there's no built-in function to do this. You can, however,
do it with a regex. Assuming the numbers are all integers (no
decimal points), then this will work:

formatted_n = n.to_s.reverse.gsub(/...(?=.)/,'\&,').reverse

-Mark

[Robert Klemme]

"Mark J. Reed" <markjreed@mail.com> schrieb im Newsbeitrag
news:20030805150600.GD28141@mulan.thereeds.org...

> On Tue, Aug 05, 2003 at 11:55:12PM +0900, Chris Morris wrote:

> > I'm brain dead and just trying to get formatted numbers in a task

that's

> > already 10 tangents deep -- argh. Anyway, how can I sprintf (or
> > otherwise) this:
> >
> > 456778904
> >
> > to this:
> >
> > 456,778,904

>
> Unless there's something I don't know about - a distinct possibility
> - there's no built-in function to do this. You can, however,
> do it with a regex. Assuming the numbers are all integers (no
> decimal points), then this will work:
>
> formatted_n = n.to_s.reverse.gsub(/...(?=.)/,'\&,').reverse

This fails for negative numbers in the range -100..-999 and all other
negative numbers with an amount of digits that is divisable by 3.

Alternative:

def format(num)
s = num.to_s

if s.include? ?.
pre, post = s.split '.'
"#{pre.reverse.gsub( /\d{3}(?=\d)/, '\&,' ).reverse}.#{post}"
else
s.reverse.gsub( /\d{3}(?=\d)/, '\&,' ).reverse
end
end

robert

[Robert Klemme]

"Chris Morris" <chrismo@clabs.org> schrieb im Newsbeitrag
news:3F2FCA9F.4000600@clabs.org...

> Chris Morris wrote:
>

> > I'm brain dead and just trying to get formatted numbers in a task
> > that's already 10 tangents deep -- argh. Anyway, how can I sprintf (or
> > otherwise) this:
> >
> > 456778904
> >
> > to this:
> >
> > 456,778,904
> >

> Found this: [url]http://www.rubygarden.org/ruby?FixNumFormat[/url]

Due to probs with negative numbers I added another version to that.

robert

[Tom Copeland]

On Tue, 2003-08-05 at 12:07, Warren Brown wrote:

> If you want to allow a decimal point:
>
> irb(main):001:0> puts "-123456789.01".gsub(/(\d)(?=\d{3}+(\.\d*)?$)/, '\1,')
> -123,456,789.01
>
> - Warren Brown

Immortalized here:

[url]http://rubyforge.org/snippet/detail.php?type=snippet&id=8[/url]

Yours,

tom

[Xavier Noria]

On Tuesday 05 August 2003 18:07, Warren Brown wrote:

> >> Yet another regex solution:
> >>
> >> % ruby -e 'puts "456778904".gsub(/(.)(?=.{3}+$)/, %q(\1,))'
> >> 456,778,904
> >>
> >> -- fxn
> >>
> >> .gsub(/(\d)(?=\d{3}+$)/, '\1,')

> >
> > That spurious line at the end uses a regex that works for negative
> > numbers as well.

>
> If you want to allow a decimal point:
>
> irb(main):001:0> puts "-123456789.01".gsub(/(\d)(?=\d{3}+(\.\d*)?$)/,
> '\1,') -123,456,789.01

But:

irb(main):003:0> puts "-123456789.0123".gsub(/(\d)(?=\d{3}+(\.\d*)?$)/, '\1,')
-123,456,789.0,123

Is that the expected behaviour? Which is the convention in the decimal part?

-- fxn

[Warren Brown]

> irb(main):001:0> puts

> "-123456789.01".gsub(/(\d)(?=\d{3}+(\.\d*)?$)/,'\1,')
> -123,456,789.01

Whoops,

irb(main):001:0> puts
"-123456789.012345".gsub(/(\d)(?=\d{3}+(\.\d*)?$)/,'\1,')
-123,456,789.012,345


How about:

irb(main):028:0> puts
"-123456789.123456789".gsub(/(\d)(?=\d{3}+(?:\.|$))(\d{3}\..*)?/,'\1,\2')
-123,456,789.123456789

- Warren Brown