Fwd: Comma Delimited Import Error

[Greg Willits]

On Jun 5, 2004, at 11:40 PM, David Blomstrom wrote:

> Here are a few rows from the comma delimited file I
> imported. Do you have a hunch what might be going on
> here?
>
> Thanks.
>
> "gd","oat",239,,"Grenada","nat"
> "gp","oat",240,,"Guadeloupe","dep"
> "ht","oat",241,,"Haiti","nat"
> "is","oat",242,,"Iceland","nat"
> "jm","oat",243,,"Jamaica","nat"

Do you see where you have two commas together such as

	239,,"Grenada"

If the field that lines up with the field between ,, does not allow 
NULL, then an error will occur. Either redefine the field to allow 
NULL, or use regex on that file to convert ,, to ,"", or ,0, as 
appropriate.

-- greg willits