An ActiveRecord extension for properly parsing strings with commas as input to numeric columns.
Ruby
Switch branches/tags
Nothing to show
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
lib
.document
.gitignore
.rspec
Gemfile
LICENSE.txt
README.md
Rakefile
ar_strip_commas.gemspec

README.md

ar_strip_commas

This gem adds a class method to ActiveRecord::Base for automatically handling the conversion of strings with commas ("1,203") to the intended value on numeric columns.

self.strip_commas_from_all_numbers

Remove commas from all numeric columns. e.g.

class Widget < ActiveRecord::Base
  strip_commas_from_all_numbers
end
widget = Widget.new(:price => "1,200", :weight => "1,872.0")
widget.price == 1200     # true
widget.weight == 1872.0  # true

Installation

Add this line to your application's Gemfile:

gem 'ar_strip_commas'

And then execute:

$ bundle

Or install it yourself as:

$ gem install ar_strip_commas

The right way?

I'm surprised I couldn't find anything built into rails for handling this. If someone knows the "right way" to handle this, send me an email and I'll replace this project with a readme describing it.