Tushar Gandhi wrote: > Hi, > I am doing a finctionality to import csv file. > My CSV file is like this > Header-- Name,Address,Details > Data-- Tushar, sangavi,pune, I am a ror developer > > My controller code is:- > @parsed_file=CSV::Reader.parse(params[:dump][:file]) > @parsed_file.each do |row| > p row[1] > p row[2] > end > > My problem is if you looked at it that address is "sangavi,pune". But > whenever I am printing the row values. I am getting row[1] as "sangavi" > and row[2] as "pune", which is not correct, Can anyoneone tell me how > should I solve this problem?
The data is being parsed correctly, it's the data format that is incorrect. For sanity's sake, strings should always be delimited by double-quotes in CSV, as in: "Tushar","sangavi, pune","I am a ror developer" The line Tushar, sangavi, pune, I am a ror developer has 4 elements which are comma separated. Given that one of your fields is 'details', what happens if the data is: Tushar, sangavi, pune, I am a ror developer, and I like curry, cricket, and Bollywood movies. Enclose those strings in quotes. -- 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 [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
