Your first instinct is correct, a parsing script in the language of your choice would make short work of this.
- michael On 7/6/07, Scott Swaim <[EMAIL PROTECTED]> wrote:
I have a text file that is in the Panasonic DBS format. It is a log file that comes from my phone system. I have a program that monitors the serial port and write the input to a file. I have no control over the format of the file. I would like to on a nightly basis shut down the logging program and then upload this file to Mysql. What I don't know how to do is to have the file split into the correct fields. Here is a sample of the file MO 07/03 13:58:00 00:00:34 103 18172959782 04 MO 07/03 13:58:00 00:00:24 103 8175177982 05 MO 07/03 13:59:00 00:00:23 103 8175177982 04 MO 07/03 13:53:00 00:07:25 105 180044454450000000 06 MI 07/03 14:00:00 00:01:55 100 8177740741 01 It is a fixed format so I could probably just write a script that parses the program Or write a script that adds a comma to the correct location. Does anyone have any suggestions or already have something that does this? Thanks in Advanced Scott Swaim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- - michael dykman - [EMAIL PROTECTED] - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]