On Fri, Aug 09, 2002 at 01:35:03PM -0400, Stephane Legault/Quebec/IBM wrote: > but when de DATE is blank I receive a message from DB telling me > that the format of the date is not good!!! > > Someone can help me???
Test if the variable storing the date field is the empty string. If
it is, unsert undef (NULL) rather than the empty string.
> TEXT FILE
> no;date;text;blablabla
Something like this:
while (<>) {@a=split /;/; undef $a[1] unless $a[1];}
dd
--
David Dooling
