At 7:19 + 9/27/06, [EMAIL PROTECTED] wrote:
hi, everyone!
I have a text file like this:
10:10:00 0 0 1 99
10:20:00 0 0 1 99
10:40:00 11 3 4 83
11:00:00 1 1 2 97
11:05:00 2 1 1 96
sed -r "s/ +/\t/g" infile.txt
or
perl -e "s/\s+/\t/g and print $_.\"\n\" while <>" < infile.txt
--
Chris Wagner
CBTS
GE Aircraft Engines
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I'm used to hammering all kinds of data into MySQL. Often I do it with a PHP
(or Perl) script that handles this kind of thing well. However, often my
data originates on a PC (don't ask), so I run it through MS Excel. Excel
(and OpenOffice, I presume) has good tools for parsing text files, and can
t
[EMAIL PROTECTED] wrote:
hi, everyone!
I have a text file like this:
10:10:00 0 0 1 99
10:20:00 0 0 1 99
10:40:00 11 3 4 83
11:00:00 1 1 2 97
11:05:00 2 1 1 96
I need to load this fi
