How to convert text files to csv output in php_PHP tutorial

How to convert text files to csv output in php

This article mainly introduces the method of converting text files to csv output in php, and realizes text by inheriting and extending the SplFileObject class The file conversion and output function is a very practical skill. Friends who need it can refer to it

The example in this article describes the method of converting text files into csv output in php. Share it with everyone for your reference. The specific implementation method is as follows:

This class provides a quick and easy way to convert a fixed-width CSV file. It can be used to perform an iteration using a SplFileObject, making it very efficient. An iterator only knows the current member, and options are provided to specify line characters and Field delimiter ends, This from CSV files. This class is particularly useful if data needs to come from a fixed-width file and be inserted into a database, since most databases support data input from CSV files.

A convenient feature of this class is the ability to skip a field if it is not needed in the output, an array of the fields is provided, providing a key/value pair, with the primary holding the value offset, or starting the field's status, and the value contains the width, or length of the field, For example. For example, 12="10 is a field that starts at 12 bits and the width, or length of the field, is 10 characters.

The bottom line character of

defaults to "n", but can be set to any character.

The

delimiter defaults to a comma, but can be set to any character, or character.

The output from the file can be used directly, written to a file, inserted into a database or for any other purpose.

PHP example code is as follows:

The code is as follows:

/**
* 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 UsageExample usage

The code is as follows:

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 ();
}
?>

I hope this article will be helpful to everyone’s PHP programming design.

http://www.bkjia.com/PHPjc/975884.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/975884.htmlTechArticleHow to convert text files to csv output in php. This article mainly introduces how to convert text files to csv output in php. , realize text file conversion and input by inheriting and extending the SplFileObject class...