How can substr() or explode() functions in PHP be used to extract specific data from a string in a CSV file?

To extract specific data from a string in a CSV file using PHP, you can use the substr() function to extract a portion of the string based on character positions or the explode() function to split the string into an array based on a delimiter (such as a comma in a CSV file). By using these functions, you can easily access and manipulate the data within the CSV file. 

// Example code snippet to extract specific data from a CSV file using substr() or explode()

// Open the CSV file
$file = fopen('data.csv', 'r');

// Read each line of the CSV file
while (($data = fgetcsv($file)) !== false) {
    // Extract specific data using substr()
    $specificData = substr($data[0], 0, 5); // Extract the first 5 characters from the first column
    
    // Extract specific data using explode()
    $dataArray = explode(',', $data[1]); // Split the second column by comma into an array
    
    // Output the extracted data
    echo $specificData . '<br>';
    print_r($dataArray);
}

// Close the CSV file
fclose($file);

Keywords

substr explode PHP string CSV file

Related Questions