text file into database
Posted: Mon Jun 20, 2005 3:35 am
hello, i have here a text file whose data contains this kind of format, i hope someone could help me to import this kind of data into a mysql database, it is like a call format which contains the time of call, the trunk,the duration and other stuff. I need to seperate all those data and insert it in the database, the portion in the file which contains this kind of format (eac99e80-ec1f-11d9-9887-00c07b9aa0c4) is a unique one. and every call in this text file have 4 lines meaning 4 similar charracter like the one in parenthesis. hope someone could give me an idea, below is a single call format of the said test file.
thanks so much!
Any similar tutorial will do.. thanks!
The x.x.x here are kind of gateway, ssome of them are like IP address.start 06/20/2005 16:21:35 eac99e80-ec1f-11d9-9887-00c07b9aa0c4
X.X.X:X.X.X:11:3:3:2 ?@(?,?,?):(00441253736755,00441253736755) --> X.Default:X.X.X --> X.X.X.Default:X.X.X
start 06/20/2005 16:21:35 eac99e80-ec1f-11d9-9887-00c07b9aa0c4
X.X.X:X.X.X:01:6:8:21 ?@(?,?,?):(00441253736755,00441253736755) --> X.X.XDefault:X.X.X--> X.X.X.Default:X.X.X
stop 06/20/2005 16:24:26 eac99e80-ec1f-11d9-9887-00c07b9aa0c4
X.X.X:X.X.X:01:6:8:21 171 seconds (2.85 minutes) normalDrop
stop 06/20/2005 16:24:26 eac99e80-ec1f-11d9-9887-00c07b9aa0c4
thanks so much!
Any similar tutorial will do.. thanks!