protected function detectDialect($data)
{
// if dialect isn't specified in the constructor, the reader will attempt to figure out the format
$autodetect = new Csv_AutoDetect();
$dialect = $autodetect->detect($data);
// @todo Header detection isn't quite right (need to remove the first row from iteration)
/*if ($autodetect->hasHeader($data)) {
$this->rewind();
pre($this->loadRow());
$this->setHeader($this->loadRow());
}*/
return $dialect;
}
protected function detectDialect($data)
{
// if dialect isn't specified in the constructor, the reader will attempt to figure out the format
$autodetect = new Csv_AutoDetect();
return $autodetect->detect($data);
}
/**
* @param $file
* @return \Csv_Dialect
*/
public static function determineCsvDialect($file)
{
// minimum 10 lines, to be sure take more
$sample = "";
for ($i = 0; $i < 10; $i++) {
$sample .= implode("", array_slice(file($file), 0, 11));
// grab 20 lines
}
try {
$sniffer = new \Csv_AutoDetect();
$dialect = $sniffer->detect($sample);
} catch (\Exception $e) {
// use default settings
$dialect = new \Csv_Dialect();
}
// validity check
if (!in_array($dialect->delimiter, array(";", ",", "\t", "|", ":"))) {
$dialect->delimiter = ";";
}
return $dialect;
}
/**
* determines CSV Dialect
*
* @static
* @param $file
* @return Csv_Dialect
*/
public static function determineCsvDialect($file)
{
// minimum 10 lines, to be sure take more
$sample = "";
for ($i = 0; $i < 10; $i++) {
$sample .= implode("", array_slice(file($file), 0, 11));
// grab 20 lines
}
try {
$sniffer = new Csv_AutoDetect();
$dialect = $sniffer->detect($sample);
} catch (Exception $e) {
// use default settings
$dialect = new Csv_Dialect();
}
return $dialect;
}
