date format 2005-04-11 00:00:00.000

[yxez]

Thanks davey...
I have this very problematic text file too converted from our MS-sqlserver. The text file contains some rows which are wrapping to the next line. This is usually caused when u allowed to enter wrapped paragraph in the column like REMARKS or ADDRESSES. the
record will split into 2 lines where it encounter the ENTER character.

And also the same with the sepator like optionally enclosed by '"'
some of the ADDRESS colums contains the '"' within thus creating
error like ."McDonald"s Residence",....,

Can you give hint how to handle this problem?

Thanks