Re: fields separator

2006-09-28 Thread Paul DuBois
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

Re: fields separator

2006-09-27 Thread Wagner, Chris (GEAE, CBTS)
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]

RE: fields separator

2006-09-27 Thread Jerry Schwartz
gt; From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 27, 2006 3:20 AM > To: mysql@lists.mysql.com > Subject: fields separator > > hi, everyone! > I have a text file like this: > 10:10:00 0 0 1 99 > 10:20:00 0

Re: fields separator

2006-09-27 Thread Chris
[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

fields separator

2006-09-27 Thread danieldinu
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 file into a table, but I cann