title: Importing CSV quoting error is driving me nuts
body: <p>I've been having an unbelievable time trying to import a CSV file in ruby-1.9.2.</p>
  
  <p>The file I am trying to parse has:</p>
  
  <ul>
  <li>commas within columns</li>
  <li>quotes within columns</li>
  <li>uses an '@' as the :col_sep</li>
  </ul>
  
  <p>csv.txt (representative input, real one is 101k lines):</p>
  
  <pre><code>㔾@㔾@jié@"seal" radical in Chinese characters, (Kangxi radical 26)
  </code></pre>
  
  <p>My code:</p>
  
  <pre><code>require 'csv'
  
  CSV.foreach("/Users/adam/Desktop/csvtest.txt", {:col_sep =&gt; "@"}) do |row|
      puts row.to_s 
  end
  </code></pre>
  
  <p>My desired output:</p>
  
  <pre><code>["㔾", "㔾", "jié", "\"seal\" radical in Chinese characters, (Kangxi radical 26)"]
  </code></pre>
  
  <p>What I get for output:</p>
  
  <pre><code>CSV::MalformedCSVError: Unclosed quoted field on line 1.
  from /Users/adam/.rvm/rubies/ruby-1.9.2-p290/lib/ruby/1.9.1/CSV.rb:1910:in `block in shift'
  from /Users/adam/.rvm/rubies/ruby-1.9.2-p290/lib/ruby/1.9.1/CSV.rb:1825:in `loop'
  from /Users/adam/.rvm/rubies/ruby-1.9.2-p290/lib/ruby/1.9.1/CSV.rb:1825:in `shift'
  from /Users/adam/.rvm/rubies/ruby-1.9.2-p290/lib/ruby/1.9.1/CSV.rb:1767:in `each'
  from /Users/adam/.rvm/rubies/ruby-1.9.2-p290/lib/ruby/1.9.1/CSV.rb:1202:in `block in foreach'
  from /Users/adam/.rvm/rubies/ruby-1.9.2-p290/lib/ruby/1.9.1/CSV.rb:1340:in `open'
  from /Users/adam/.rvm/rubies/ruby-1.9.2-p290/lib/ruby/1.9.1/CSV.rb:1201:in `foreach'
  from (irb):31
  from /Users/adam/.rvm/rubies/ruby-1.9.2-p290/bin/irb:16:in `&lt;main&gt;'
  </code></pre>
  
  <p>It says there are unclosed quoted feilds, but I can see that the quotes open and close.</p>
  
  <p>Escaping the quotes does nothing. I get the same error (<code>...@""seal"" r...</code>).
  Changing them to single quotes makes it work (<code>...@'seal' r...</code>).
  The problem is I NEED them to be in double quotes.</p>
  
  <p>Any ideas?</p>