Skip to content
This repository has been archived by the owner on Jan 24, 2019. It is now read-only.

redcatphp/csv-tools

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

3 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

No longer actively maintained. I work now with NodeJS and I recommand you to take a look at PapaParse

#CSV Tools

###taken from DelimiterFinder https://github.com/darraghenright/DelimiterFinder with composer, namespace and autoload support

A little utility class that reads a .csv or .dat (or whatever) file and tries to guess the delimiter

##Usage

###Create an instance

Include the file and create a new instance in the usual way; the constructor takes a filepath as a required argument:

require_once dirname(__FILE__) . '/DelimiterFinder.php';

try {
    $finder = new DelimiterFinder('path/to/data.csv');
} catch (InvalidArgumentException $e) {
    // file does not exist :o 
} catch (RuntimeException $e) {
    // file is not readable :(
}

The object will try to open a file handle on the filepath provided. If the file is unreadable or non-existent exceptions will be thrown.

###Find

Assuming all went smoothly to this point, it's time to try to guess the delimiter.

The class searches for a likely delimiter from the following list of usual suspects:

  • comma (,), tab (\t) or semicolon (;)

Just call the find method:

$delimiter = $finder->find();

If successful, find() stores and returns the matched delimiter. Subsequent calls to do not search the document again; they just return the stored match.

###If at first you don't succeed...

If a match is not successful, the find() method returns false. Subsequent calls to find() will search the document again. You can add any number of custom delimiters to search, which makes repeat searches a little more useful ;)

$finder->addDelimiter('|');
$delimiter = $finder->find(); // pipe-delimited file? success!

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Packages

No packages published