On Wed, 2007-01-10 at 16:51, garrettmoore@gmail.com wrote:
> The missing quote after Poster is a mistake I made when sanitzing the
> data for posting here. That error is NOT present in the actual data.
> There is a quote where needed in the data. So, with that in mind, why
> am I still getting the error?
>
> Also, there is no symbol we can expect to not be in the data. This data
> is from several sources, including a message board, and there could be
> tildes, pipes, or any other symbol in discussion fields.
>
> Also since it's CSV we just have null represented by lack of any value
> between two commas, so: a,b,,d represents a row with values a, b, NULL,
> d. This works fine in general.
Can you make a sanitized test case, complete unto itself, and post that?
The data to look for are generally \ and '