Re: Parsing Text File

This is all really straight forward stuff. Here's some code that will get the file parsed to an array, what you do from there is up to you. <?php $open = fopen("file.txt","r+"); while($contents = fgets($open)) { $line_array[$x] = $contents; $x++; } ?> Note: if you have a precise structure for your lines you can say to read from point a to b using substr(). For example, let's say the first name is exactly 3 characters in from 0 and exactly 10 characters long so you could do substr($line_array[0], 3, 10); This is a really dirty way to handle this and I'm sure there are better ways so poke around a bit. Also if you have your phone number located down to a specific location you can use an explode statement to get both area code and main number seperated.. ----- Original Message ----- From: Jason D. Williard Sent: Saturday, June 15, 2002 1:28 PM To: php-general@lists.php.net Subject: [PHP] Parsing Text File I am trying to input data from a text file into a MySQL database and would like to be able to input the data using a single script. What's the easiest way to parse a line, such as below, and turn it into variables to be placed in the database. While I can simply place the data in by importing from a file, it's not quite so easy. I only need to place some of the data in, plus I would like to split one of the fields. Below is an example of a line from the file, and then the variables that I need to enter. Here is an example of a line from the file: Number,City,State,Country,Provider,Isdn,56K,CreateDate,Active,Timezone,ModDa te,ModNote 403 -770 -4904 ,CALGARY,AB,CAN,T2,Y,Y,Apr 29 2002 12:00:00:000AM,I,GMT-0700,, As for variables, I need the following: Split Number into $AreaCode & $Number > 403 & 770-4904 $City $State $Country Thanks for any help. Jason D. Williard -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.phpGet more from the Web. FREE MSN Explorer download : http://explorer.msn.com