php将文本文件转换csv输出的方法
网络编程 2021-07-05 09:50www.168986.cn编程入门
这篇文章主要介绍了php将文本文件转换csv输出的方法,通过对SplFileObject类的继承与扩展实现文本文件转换输出的功能,是非常实用的技巧,需要的朋友可以参考下
本文实例讲述了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.
@version $Id$
/
class fixed2CSV extends SplFileObject
{
/
Constructor, duh, calls the parent constructor
@aess 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
@aess 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 aess a non-existing property
@aess 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
@aess 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
?>
/
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.
@version $Id$
/
class fixed2CSV extends SplFileObject
{
/
Constructor, duh, calls the parent constructor
@aess 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
@aess 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 aess a non-existing property
@aess 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
@aess 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 ();
}
?>
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使用google地图应用实例
下一篇:19个Android常用工具类汇总
编程语言
- 如何快速学会编程 如何快速学会ug编程
- 免费学编程的app 推荐12个免费学编程的好网站
- 电脑怎么编程:电脑怎么编程网咯游戏菜单图标
- 如何写代码新手教学 如何写代码新手教学手机
- 基础编程入门教程视频 基础编程入门教程视频华
- 编程演示:编程演示浦丰投针过程
- 乐高编程加盟 乐高积木编程加盟
- 跟我学plc编程 plc编程自学入门视频教程
- ug编程成航林总 ug编程实战视频
- 孩子学编程的好处和坏处
- 初学者学编程该从哪里开始 新手学编程从哪里入
- 慢走丝编程 慢走丝编程难学吗
- 国内十强少儿编程机构 中国少儿编程机构十强有
- 成人计算机速成培训班 成人计算机速成培训班办
- 孩子学编程网上课程哪家好 儿童学编程比较好的
- 代码编程教学入门软件 代码编程教程