php 将文本文件转换csv输出

这个类提供了转换成固定宽度的CSV文件,快速,简便的方法,它可将SplFileObject用于执行迭代,使它非常高效的一个迭代只知道当前成员,期权是提供给指定行字符和字段分隔符结束,This from CSV files.这个类是特别有用的,如果数据需要来自一个固定宽度的文件,并插入到数据库中,因为大多数的数据库支持从CSV文件中的数据输入.

这一类的方便的功能是可以跳过字段如果不是在输出需要,该领域的阵列提供,提供了一个键/值对,与主要持有的价值偏移,或启动领域的地位,和值包含的宽度,或字段的长度,For example.例如,12 =“10是一个领域,在12位和宽度或字段的长度为10个字符开始.

底的行字符默认成" n"，而是可以设置为任何字符。

分隔符默认为一个逗号,但可以设置为任何字符，或字符。

.从文件的输出可以直接使用,写入一个文件,到数据库或任何其他目的插入.

PHP实例代码如下:

<?php
/**  
 * Class to convert fixed width files into CSV format
 * Allows to set fields, separator, and end-of-line character
 *
 * @author Kevin Waterson
 * @url http://phpro.org
 * @version $Id$
 *
 */
class fixed2CSV extends SplFileObject {
    /**  
     *
     * Constructor, duh, calls the parent constructor
     *
     * @access       public
     * @param    string  The full path to the file to be converted
     *
     */
    public function __construct($filename) {
        parent::__construct($filename);
    }
    /*
     * Settor, is called when trying to assign a value to non-existing property
     *
     * @access    public
     * @param    string    $name    The name of the property to set
     * @param    mixed    $value    The value of the property
     * @throw    Excption if property is not able to be set
     *
    */
    public function __set($name, $value) {
        switch ($name) {
            case &#39;eol&#39;:
            case &#39;fields&#39;:
            case &#39;separator&#39;:
                $this->$name = $value;
                break;
            default:
                throw new Exception("Unable to set $name ");
        }
    }
    /**  
     *
     * Gettor This is called when trying to access a non-existing property
     *
     * @access    public
     * @param    string    $name    The name of the property
     * @throw    Exception if proplerty cannot be set
     * @return    string
     *
     */
    public function __get($name) {
        switch ($name) {
            case &#39;eol&#39;:
                return " ";
            case &#39;fields&#39;:
                return array();
            case &#39;separator&#39;:
                return &#39;,&#39;;
            default:
                throw new Exception(" $name cannot be set");
        }
    }
    /**  
     *
     * Over ride the parent current method and convert the lines
     *
     * @access    public
     * @return    string    The line as a CSV representation of the fixed width line, false otherwise
     *
     */
    public function current() {
        if (parent::current()) {
            $csv = &#39;&#39;;
            $fields = new cachingIterator(new ArrayIterator($this->fields));
            foreach ($fields as $f) {
                $csv.= trim(substr(parent::current() , $fields->key() , $fields->current()));
                $csv.= $fields->hasNext() ? $this->separator : $this->eol;
            }
            return $csv;
        }
        return false;
    }
} // end of class
?> 
 
Example Usage示例用法 
 
<?php
try {
    /*** the fixed width file to convert ***/
    $file = new fixed2CSV(&#39;my_file.txt&#39;);
    /*** The start position=>width of each field ***/
    $file->fields = array(
        0 => 10,
        10 => 15,
        25 => 20,
        45 => 25
    );
    /*** output the converted lines ***/
    foreach ($file as $line) {
        echo $line;
    }
    /*** a new instance ***/
    $new = new fixed2CSV(&#39;my_file.txt&#39;);
    /*** get only first and third fields ***/
    $new->fields = array(
        0 => 10,
        25 => 20
    );
    
    /*** output only the first and third fields ***/
    foreach ($new as $line) {
        echo $line;
    }
}
catch(Exception $e) {
    echo $e->getMessage();
}
?>

教程地址：

欢迎转载！但请带上文章地址^^