Multiple field separators

2001-09-26 Thread Charles Lewis
Hi. 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 separator is a , and the time and message

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 separator is

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 my

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:24 : Text