《PHP實例：php將文本文件轉換csv輸出的方法》要點：
本文介紹了PHP實例：php將文本文件轉換csv輸出的方法，希望對您有用。如果有疑問，可以聯系我們。
本文實例講述了php將文本文件轉換csv輸出的辦法.分享給大家供大家參考.具體實現辦法如下：PHP實例
這個類提供了轉換成固定寬度的CSV文件,快速,簡便的辦法,它可將SplFileObject用于執行迭代,使它非常高效的一個迭代只知道當前成員,期權是提供給指定行字符和字段分隔符結束,This from CSV files.這個類是特別有用的,如果數據需要來自一個固定寬度的文件,并插入到數據庫中,因為大多數的數據庫支持從CSV文件中的數據輸入.PHP實例
這一類的方便的功能是可以跳過字段如果不是在輸出需要,該領域的陣列提供,提供了一個鍵/值對,與主要持有的價值偏移,或啟動領域的地位,和值包含的寬度,或字段的長度,For example.例如,12 =“10是一個領域,在12位和寬度或字段的長度為10個字符開始.PHP實例
底的行字符默認成“ n”,而是可以設置為任何字符.PHP實例
分隔符默認為一個逗號,但可以設置為任何字符,或字符.PHP實例
從文件的輸出可以直接使用,寫入一個文件,到數據庫或任何其他目的插入.PHP實例
PHP實例代碼如下:
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 'eol' :?
case 'fields' :?
case 'separator' :?
$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 'eol' :?
return " " ;
?
case 'fields' :?
return array();
?
case 'separator' :?
return ',' ;
?
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 = '' ;?
$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 ( 'my_file.txt' );
?
/*** 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 ( 'my_file.txt' );
?
/*** 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 ();?
}
?>
希望本文所述對大家的php程序設計有所贊助.PHP實例
《PHP實例：php將文本文件轉換csv輸出的方法》是否對您有啟發，歡迎查看更多與《PHP實例：php將文本文件轉換csv輸出的方法》相關教程，學精學透。維易PHP學院為您提供精彩教程。
轉載請注明本頁網址：
http://www.fzlkiss.com/jiaocheng/12858.html
