[RESOLVED] General Guidance on parsing filename

[bluto374]

I have a file name loaded into an array which was read from a csv file. The file format is given to me with erroneous data in the file name. I am trying to loop through the file name character by character and check to see if the file name exist in the current directory, once there is a match, return the shortened name. I have the following code to read in the information.

Example of $line[8]

Thumb_1_3_2_45678.jpg
Large_1_2_45343.jpg
XL_2_3_5_23132.gif

$in = fopen('input.txt', 'r');
$out = fopen('output.txt, 'w');
$
while(($line = fgetcsv($in, 0, ',')) !== false)
{
     $search = $line[8];
     $output = //Somehow read from the last charactar right to left until there is an exact match in the directory "./images" and put that value into $new_array.
     if (file_exist ($output)){
        $correct_output = // The matched name of the file.
        fputcsv($out, /*The new matched name of the file/*, ','); 
     }


}

[bpat1434]

Probably something like:

$in = fopen('input.txt', 'r');
$out = fopen('output.txt', 'w');

// Check used later...
$pre520 = version_compare(phpversion(), '5.2.0', '<');

while(($line = fgetcsv($in, 0, ',')) !== false)
{
    $search = $line[8];

$basename = pathinfo($search);
// Previous to 5.2, pathinfo() doesn't give the value of "filename", so we'll get it
if($pre520)
{
    $basename['filename'] = substr($basename['basename'], 0, strlen($basename['extension'])+1);
}

$i = strlen($basename['filename']);
while($i > 0)
{
    $filename = substr($basename['filename'], 0, $i).'.'.$basename['extension'];

    if(file_exists($filename))
    {
        fputcsv($out, $filename, ',');
        break; // Break out of this while
    }

    $i--;
}
}

Hope that helps.

[bluto374]

Thank you so much! Here is the final code to remove the erroneous filename and replace with the name that exist. I had to modify a few things to get the output I wanted, but this is a great solution for my problem. Thanks again!

$in = fopen('input.txt', 'r');
$out = fopen('output.txt', 'w');

// Check used later...
$pre520 = version_compare(phpversion(), '5.2.0', '<');

while(($line = fgetcsv($in, 0, ',')) !== false)
{
    $search = $line[9];

$basename = pathinfo($search);
// Previous to 5.2, pathinfo() doesn't give the value of "filename", so we'll get it
if($pre520)
{

    $basename['filename'] = substr($basename['basename'], 0, strlen($basename['extension'])+1);
}

$i = strlen($basename['basename']);
$a = '0';
while($i > $a)
{
    $filename = substr($basename['filename'].'.'.$basename['extension'], $a, $i);
    if(file_exists($filename))
    {
        $a = array($filename);
		fputcsv($out, $a, ',');
        break; // Break out of this while
    }
	++$a;

}
} 

[bpat1434]

Be careful. You reuse $a so it turns from a numeric string, to an array. Then you increment it. I'm surprised that's not flipping out at you.

Secondly, $i should only be the strlen of $basename['filename'] not $basename['basename'] as $basename['filename'] strips off the extension so you're left with "index" from "index.html".

Glad I could help out.

[bluto374]

You are right, I copied and pasted the code before I finalized it. the correct version is :
For whatever reason, I have version 5.2.12 and when I use $basename['filename'] it strips the extension off, the only way for me to get it to wrok correctly was to use $basename['basename']. Maybe the is an undocumented feature...LOL

$in = fopen('input.txt', 'r');
$out = fopen('output.txt', 'w');

// Check used later...
$pre520 = version_compare(phpversion(), '5.2.0', '<');

while(($line = fgetcsv($in, 0, ',')) !== false)
{
    $search = $line[9];

$basename = pathinfo($search);
// Previous to 5.2, pathinfo() doesn't give the value of "filename", so we'll get it
if($pre520)
{

    $basename['filename'] = substr($basename['basename'], 0, strlen($basename['extension'])+1);
}

$i = strlen($basename['basename']);
$a = '0';
while($i > $a)
{
    $filename = substr($basename['filename'].'.'.$basename['extension'], $a, $i);
    if(file_exists($filename))
    {
        $f = array($filename);
        fputcsv($out, $f, ',');
        break; // Break out of this while
    }
    ++$a;

}
}