Jump to content

Need some guidance


elentz

Recommended Posts

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.

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.