On Wed, 2007-01-10 at 16:51, garrettmoore@xxxxxxxxx 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 '
