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