I have data from database seperated by commas
the format:
(lastname),,(firstname),(middlename),(lastname),,(firstname),(middlename),(lastname),,(firstname),(middlename)
I want to be able to pull out
(lastname),,(firstname),(middlename)
or possibly put a /n in
(lastname),,(firstname),(middlename)/n
(lastname),,(firstname),(middlename)/n
example:
SMITH,,JOHN,DAYTON,CUMMINGS,,MIKE,ALLEN,CLANTON,,HOMER,WILL,WILSON,,MORGAN,JOE
I just don't know how to go about doing this.
Thanks for any help
--pb
data seperated by commas
Moderator: General Moderators
-
penguinboy
- Forum Contributor
- Posts: 171
- Joined: Thu Nov 07, 2002 11:25 am
RFTM 
http://www.php.net/manual/en/function.fgetcsv.php
That works best with 1 record per line:
lastname),,(firstname),(middlename)/n
(lastname),,(firstname),(middlename)/n
alternatively:
http://www.php.net/manual/en/function.fgetcsv.php
That works best with 1 record per line:
lastname),,(firstname),(middlename)/n
(lastname),,(firstname),(middlename)/n
alternatively:
Code: Select all
$csv = file('db.csv');
$records = 0;
for($x = 0; $x < count($csv); $x++) {
$currentline = ereg_replace('ї\n\r]+','',$csvї$x]);
$data = split(',' $currentline);
while( sizeof($data) > 0 ) {
$recordї$records]їlastname] = array_shift($data);
$recordї$records]їblank] = array_shift($data);
$recordї$records]їfirstname] = array_shift($data);
$recordї$records]їmiddlename] = array_shift($data);
$records++;
}
}