SeparatedValues

This is a gem for easily parsing primitive data sheet files. It supports file types like CSV and TSV to name a few.

Add this line to your application's Gemfile:

gem 'separated_values'

And then execute:

$ bundle

Or install it yourself as:

$ gem install separated_values

Parsing a file:

document = SeparatedValues.parse('my_file.csv')

As you might guess the document file contains the contents of the file. You can access the cell values as a two dimensional array.

document[0][0] = 'foo'

The parser will default to parse CSV files. If you want to parse a custom format you can use the :separator option.

document = SeparatedValues.parse('my_file.tsv', separator: '\t')

The parser also comes with the handy :schema option. By providing this option you can convert the document to an array of hashes:

document = SeparatedValues.parse('my_file.csv', schema: [:first_name, :last_name])
document.to_hash_array
#=>
# [
#     { first_name: 'Luke', last_name: 'Skywalker' },
#     { first_name: 'Han', last_name: 'Solo' }
# ]

The keys defined in the schema will also be available as methods:

document = SeparatedValues.parse('my_file.csv', schema: [:first_name, :last_name])
document[0].first_name #=> 'Luke'

After checking out the repo, run bin/setup to install dependencies. Then, run rake spec to run the tests. You can also run bin/console for an interactive prompt that will allow you to experiment.

To install this gem onto your local machine, run bundle exec rake install. To release a new version, update the version number in version.rb, and then run bundle exec rake release, which will create a git tag for the version, push git commits and tags, and push the .gem file to rubygems.org.

Bug reports and pull requests are welcome on GitHub at https://github.com/istanful/separated-values.

The gem is available as open source under the terms of the MIT License.