Ruby CSV input value format

Question

I'm using ruby CSV module to read in a csv file.

One of the values inside the csv file is in format is XXX_XXXXX where X are number. I treat this value as string, actually, but CSV module is reading in these values as XXXXXXXX, as numbers, which I do not want.

Options I am currently using

f = CSV.read('file.csv', {:headers => true, :header_converters => :symbol, :converters => :all} )

Is there a way to tell CSV to not do that?

steenslag · Accepted Answer · 2013-03-07 23:06:33Z

2

f = CSV.read('file.csv', {:headers => true, :header_converters => :symbol)}

Leave out the :converters => :all; that one tries (amongst others) to convert all numerical looking strings to numbers.

answered Mar 7, 2013 at 23:06

steenslag

80.2k16 gold badges144 silver badges174 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

peter · Accepted Answer · 2013-03-07 23:14:15Z

1

The :convertors => all causes this, try the following

require "csv"

CSV.parse(DATA, :col_sep => ",", :headers => true, :converters => :all).each do |row|
  puts row["numfield"]
end
__END__
textfield,datetimefield,numfield
foo,2008-07-01 17:50:55.004688,123_45678
bar,2008-07-02 17:50:55.004688,234_56789

# gives
# 12345678
# 23456789

and

CSV.parse(DATA, :col_sep => ",", :headers => true).each do |row|
  puts row["numfield"]
end

__END__
textfield,datetimefield,numfield
foo,2008-07-01 17:50:55.004688,123_45678
bar,2008-07-02 17:50:55.004688,234_56789

# gives
# 123_45678
# 234_56789

answered Mar 7, 2013 at 23:14

peter

42.3k7 gold badges67 silver badges110 bronze badges

2 Comments

Ji Mun Over a year ago

Thank you! You are right. Unfortunately steenslag answered before with the same answer... so I chose his/her answer. But thank you!!

peter Over a year ago

yeah, i spended more time documenting my answer, good for the people who hit this in the future, happy coding..

Collectives™ on Stack Overflow

Ruby CSV input value format

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related