Re: Multiple field separators

2001-09-26 Thread Arjen G. Lentz
Hi Charles, - Original Message - From: "Charles Lewis" <[EMAIL PROTECTED]> > I have the following command: > mysqlimport -d -c, --columns=DATE,TIME,MSG --fields-terminated-by=, > --fields-enclosed-by=, dbase c:\file.txt > This reads the following from a text file: > 26 Sep 2001, 05:42:2

Re: Multiple field separators

2001-09-26 Thread jim barchuk
Hi Charles! > I have the following command: > mysqlimport -d -c, --columns=DATE,TIME,MSG --fields-terminated-by=, > --fields-enclosed-by=, dbase c:\file.txt > > This reads the following from a text file: > 26 Sep 2001, 05:42:24 : Text message to be read. Carl's response was perfect end negated m

Re: Multiple field separators

2001-09-26 Thread Carl Troein
Charles Lewis writes: > I have the following command: > mysqlimport -d -c, --columns=DATE,TIME,MSG --fields-terminated-by=, > --fields-enclosed-by=, dbase c:\file.txt > > This reads the following from a text file: > 26 Sep 2001, 05:42:24 : Text message to be read. > > The date and time separa