Need some guidance

[elentz]

I have a text file that will always have the same format.  It is like this:

 

Station Message Detailed Recording                          20:56:29 02-21-2008

TYP EXT#  TRUNK DIALED DIGITS                START ELAPSED  COST  ACCOUNT CODE

IN  1011  94002                              14:44 00:00:26 $00.00

NET 1001  P6011 1101                        14:47 00:00:07 $00.00

NET 1001  P6011 1105                        14:47 00:01:00 $00.00

IN  1000  94001                              14:48 00:00:31 $00.00

 

The first two lines I need to manipulate.  I need to get the date (end of first line)in a variable and then strip the rest of the first two lines out.  Then I need to insert each line into different fields into a MySql table.  I know enough that I know I need to open the file and read it.  But how do I do the manipulating?

 

Thanks for any suggestions.

[drisate]

You should trim() the files then explode() the spaces