trim()

[bob_the _builder]

In the following code, where would you use trim to clean whitespaces from fields within the csv?

 

$handle = fopen("products.csv", "r"); 
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) 
{ 
     $array[] = $data; 
} 

 

Thanks

[Mahngiel]

once it's been retrieved and you intend to process it further.

[PFMaBiSmAd]

You can use array_map to apply the trim function to all elements of your $data array.

[bob_the _builder]

Yea the next step where the array data is used is below.. But I cant be sure where to use trim on $array data

foreach($array as $eacharray) 
{         
    /* Check if product code in each line is in the array of $productcodesarray pulled from the database */ 
    if(in_array($eacharray[0],$productcodesarray)) { 

        /* The product code was found, update the record */ 
        $code = trim($eacharray[0]); 
        $description = trim($eacharray[1]);

[Barand]

$handle = fopen("products.csv", "r"); 
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) 
{ 
     $array[] = array_map('trim', $data); 
} 

[bob_the _builder]

Thanks.. array_map did the job..