Delimiter in CSV (Auto)
There is a way (i took from internet for a project) to detect a delimiter in a CSV (for the funcionalities that you have in SMA where take a CSV file)

This because depending of the configuration in EXCEL the delimiter change... sometimes is a "," or ";" and you know ...

To include in Site.php

public function detectDelimiter($csvFile)
{
$delimiters = [";" => 0, "," => 0, "\t" => 0, "|" => 0];
$handle = fopen($this->digital_upload_path . $csvFile, 'r');
$firstLine = fgets($handle);
fclose($handle);
foreach ($delimiters as $delimiter => &$count) {
$count = count(str_getcsv($firstLine, $delimiter));
}
return array_search(max($delimiters), $delimiters);
}

To invoke from any php that upload a file (CSV) in my case in Purchase.php and others...

$delimiter_auto = $this->site->detectDelimiter($csv);
....
while (($row = fgetcsv($handle, 1000, $delimiter_auto)) !== false ) {

I hope this can help you