From: Dave Burt <dave@...>
Date: 2006-05-06T06:39:49+09:00
Subject: Re: CSV::IllegalFormatError   (Need to club data entry person)

Sean Clark wrote:
> ...
> "M1234567","John","A","Doe","321 NORTH "B" 
> ST","","Sometown","ST","55555"
> 
> Is there a way to get around this error and escape the "B" properly 
> before opening the file in CSV.open, or would I be better to just flag 
> this record and move on?

Escape quotes by doubling them:

  gsub('"B"', '""B""')

Cheers,
Dave