Hello,
my goal is to import data into a MySQL-Database using FasterCSV:
Does anyone have an idea how I can force FasterCSV to ignore carriage
returns that occur within(!) a database text field and to read until
"line feed" = end or row is reached? I tried to use option
":row_sep"
but it did not work, it still uses the returns within the text field as
end of row, too:
FasterCSV.foreach("test", :headers => :first_row, :col_sep =>
",",
:row_sep => "\n") do |row|
(\n should be line feed in ruby, right?)
I also thought about replacing the return and line feed symbols by
something else, but I don''t want to loose the return-information which
I
need for displaying the text of this field in my view.
Any suggestions would be highly appreciated ...
Thanks very much,
soleil
--
Posted via http://www.ruby-forum.com/.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---