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

Reply via email to