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 need to reply :) except for one
point. You are not SOL when it comes to '*nix-style' utils. For instance
http://www.geocities.com/SiliconValley/Lakes/1401/txtfrmt.htm
Browse google for more. Try to find 'plain command line' utilities rather
than windows stuff to avoid silly win related formatting
incompatibilities.
Have a :) day!
jb
ob-filter-word: table
--
jim barchuk
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php