Now, I have an XLS file with around 10k+ groups of lines like this
Code: Select all
Matthew Overington
Technical Editor
APC Magazine
Ph: +61 2 9288 9123
Fax: +61 2 9267 4909
Web: moverington@apcmag.comCode: Select all
Matthew Overington Technical Editor APC Magazine Ph: +61 2 9288 9123 Fax: +61 2 9267 4909 Web: moverington@apcmag.comCode: Select all
Matthew Overington
Technical Editor
APC Magazine
Ph: +61 2 9288 9123
Fax: +61 2 9267 4909
Web: moverington@apcmag.comCode: Select all
<?php
function nametitleorgphfaxemail($farray)
{
if (!$handle = fopen("dbtext.txt", 'a'))
{
echo "Cannot open file ($filename)";
exit;
}
if (fwrite($handle, stripcslashes($farray[0])."\t".stripcslashes($farray[1])."\t".stripcslashes($farray[2])."\t".stripcslashes($farray[3])."\t".stripcslashes($farray[4])."\t".stripcslashes($farray[5])."\n") === FALSE) {
echo "Cannot write to file ($filename)";
exit;
}
fclose($handle);
}
$lines = file('source.txt');
$i = 0;
$count = 1;
$tarray = array();
foreach ($lines as $line_num => $line)
{
if (strlen($line) > 2)
{
$tarray[$i] = $line;
$i++;
}
else
{
if ((substr($tarray[3],0,3) == "Ph:")&&(substr($tarray[4],0,4) == "Fax:")&&(substr($tarray[5],0,4) == "Web:"))
{
nametitleorgphfaxemail($tarray);
}
else
{
for($j = 0; $j < count($tarray); $j++)
{
echo($tarray[$j]."<br>");
}
echo("<br>");
}
$i = 0;
$tarray = array();
}
}
?>So go ahead people's do your best!