In response to the getCSVValues() function posted by justin at cam dot org, my testing indicates that it has a problem with a CSV string like this:
1,2,"3,""4,5"",6",7
This parses as:
array(6) {
[0]=>
string(1) "1"
[1]=>
string(1) "2"
[2]=>
string(4) "3,"4"
[3]=>
string(1) "5"
[4]=>
string(0) ""
[5]=>
string(1) "7"
}
instead of:
array(4) {
[0]=>
string(1) "1"
[1]=>
string(1) "2"
[2]=>
string(9) "3,"4,5",6"
[3]=>
string(1) "7"
}
To fix this, I changed the second substr_count to look for an odd number of quotes, as opposed to any quotes at all:
<?php
function getCSVValues($string, $separator=",")
{
$elements = explode($separator, $string);
for ($i = 0; $i < count($elements); $i++) {
$nquotes = substr_count($elements[$i], '"');
if ($nquotes %2 == 1) {
for ($j = $i+1; $j < count($elements); $j++) {
if (substr_count($elements[$j], '"') %2 == 1) { // Look for an odd-number of quotes
// Put the quoted string's pieces back together again
array_splice($elements, $i, $j-$i+1,
implode($separator, array_slice($elements, $i, $j-$i+1)));
break;
}
}
}
if ($nquotes > 0) {
// Remove first and last quotes, then merge pairs of quotes
$qstr =& $elements[$i];
$qstr = substr_replace($qstr, '', strpos($qstr, '"'), 1);
$qstr = substr_replace($qstr, '', strrpos($qstr, '"'), 1);
$qstr = str_replace('""', '"', $qstr);
}
}
return $elements;
}
?>
split
(PHP 4, PHP 5)
split — 用正则表达式将字符串分割到数组中
说明
split
( string
$pattern
, string $string
[, int $limit
] ) : arrayTip
preg_split() 函数使用了 Perl 兼容正则表达式语法，通常是比 split() 更快的替代方案。如果不需要正则表达式的威力，则使用 explode() 更快，这样就不会招致正则表达式引擎的浪费。
本函数返回一个字符串数组，每个单元为
string 经区分大小写的正则表达式
pattern 作为边界分割出的子串。如果设定了
limit，则返回的数组最多包含
limit 个单元，而其中最后一个单元包含了
string 中剩余的所有部分。如果出错，则
split() 返回 FALSE。
将 /etc/passwd 中的前四个字段分割出来：
Example #1 split() 例子
<?php
list($user, $pass, $uid, $gid, $extra) =
split (":", $passwd_line, 5);
?>
如果字符串中有 n 个与
pattern 匹配的项目，则返回的数组将包含
n+1 个单元。例如，如果没有找到
pattern，则会返回一个只有一个单元的数组。当然，如果
string 为空也是这样。
解析可能用斜线，点，或横线分割的日期：
Example #2 split() 例子
<?php
// 分隔符可以是斜线，点，或横线
$date = "04/30/1973";
list($month, $day, $year) = split ('[/.-]', $date);
echo "Month: $month; Day: $day; Year: $year<br />\n";
?>
想仿效 Perl 中类似的 @chars = split('', $str) 行为，请参考 preg_split() 或 str_split() 函数中的例子。
注意 pattern
是一个正则表达式。如果想要用的分割字符是正则表达式中的特殊字符，要先将其转义。如果觉得
split()（或其它任何 regex 函数）行为古怪的话，请阅读包含在
PHP 发行包中 regex/ 子目录下的
regex.7 文件。该文件是手册页面格式，可以用类似
man /usr/local/src/regex/regex.7 的命令来阅读。
参见 preg_split()，spliti()，str_split()，explode()，implode()，chunk_split() 和 wordwrap()。
add a note
User Contributed Notes 25 notes
Dave Walter ¶
16 years ago
wchris ¶
19 years ago
moritz's quotesplit didn't work for me. It seemed to split on a comma even though it was between a pair of quotes. However, this did work:
function quotesplit($s, $splitter=',')
{
//First step is to split it up into the bits that are surrounded by quotes and the bits that aren't. Adding the delimiter to the ends simplifies the logic further down
$getstrings = split('\"', $splitter.$s.$splitter);
//$instring toggles so we know if we are in a quoted string or not
$delimlen = strlen($splitter);
$instring = 0;
while (list($arg, $val) = each($getstrings))
{
if ($instring==1)
{
//Add the whole string, untouched to the result array.
$result[] = $val;
$instring = 0;
}
else
{
//Break up the string according to the delimiter character
//Each string has extraneous delimiters around it (inc the ones we added above), so they need to be stripped off
$temparray = split($splitter, substr($val, $delimlen, strlen($val)-$delimlen-$delimlen ) );
while(list($iarg, $ival) = each($temparray))
{
$result[] = trim($ival);
}
$instring = 1;
}
}
return $result;
}
dalu at uni dot de ¶
21 years ago
php4.3.0
strange things happen with split
this didn't work
$vontag $vonmonat were empty strings
<?php
function ckdate($fromdate="01.01", $todate="31.12")
{
$nowyear = date("Y");
list ($vontag , $vonmonat) = split ('.' , $fromdate); // << bad
$vondatum = "$nowyear-$vonmonat-$vontag";
list ($bistag , $bismonat) = split ('.' , $todate); // << bad
$bisdatum = "$nowyear-$bismonat-$bistag";
$von = strtotime($vondatum);
$bis = strtotime($bisdatum);
$now = time();
if (($now <= $bis) and ($now >= $von))
{
return TRUE;
}
else
{
return FALSE;
}
}
?>
however this one worked perfectly
<?php
function ckdate($fromdate="01.01", $todate="31.12")
{
$nowyear = date("Y");
list ($vontag , $vonmonat) = split ('[.]' , $fromdate); // << good
$vondatum = "$nowyear-$vonmonat-$vontag";
list ($bistag , $bismonat) = split ('[.]' , $todate); // << good
$bisdatum = "$nowyear-$bismonat-$bistag";
$von = strtotime($vondatum);
$bis = strtotime($bisdatum);
$now = time();
if (($now <= $bis) and ($now >= $von))
{
return TRUE;
}
else
{
return FALSE;
}
}
?>
btw this fn checks if $now if between $fromdate and $todate
use it if you like
nomail at please dot now ¶
21 years ago
If you want to use split to check on line feeds (\n), the following won't work:
$line = split("\n", $input_several_lines_long);
You really have to do this instead, notice the second slash:
$line = split("\\n", $input_several_lines_long);
Took me a little while to figure out.
paha at paha dot hu ¶
22 years ago
It's evident but not mentioned in the documentation that using asterisks is more restricted than in a normal regular expression.
for exaple you cannot say:
split(";*",$string);
because what if there's no ";" separator?(which is covered by this regular expression)
so you have to use at least
split(";+",$quotatxt);
in this situation.
RE: gcerretini at technica dot net /UTF8 ¶
18 years ago
Original problem:
=================
I've try using split function.
<?php
$ferro="2�12";
$valore=split("[�]",$ferro);
echo $ferro."<br>";
echo "p1-".$valore[0]."<br>";
echo "p2-".$valore[1]."<br>";
echo "p3-".$valore[2]."<br>";
$ferro="2d12";
$valore=split("[d]",$ferro);
echo $ferro."<br>";
echo "p1-".$valore[0]."<br>";
echo "p2-".$valore[1]."<br>";
echo "p3-".$valore[2]."<br>";
?>
This return:
============
2�12
p1-2
p2-
p3-12
2d12
p1-2
p2-12
p3-
I use charset UTF-8. When I use char � the split function ad an empty string between "2" and "12"... Why?
Explanation:
============
UTF-8 charset codes some characters (like the "�" character) into two bytes. In fact the regular expresion "[�]" contains 4 bytes (4 non-unicode characters). To demonstrate the real situation I wrote following example:
$ferro="2de12";
$valore=split("[de]",$ferro);
echo $ferro."<br>";
echo "p1-".$valore[0]."<br>";
echo "p2-".$valore[1]."<br>";
echo "p3-".$valore[2]."<br>";
This returns:
=============
2d12
p1-2
p2-
p3-12
jeffrey at jhu dot edu ¶
21 years ago
In answer to gwyne at gmx dot net, dec 1, 2002:
For split(), when using a backslash as the delimiter, you have to *double escape* the backslash.
example:
==================================
<pre>
<?
$line = 'stuff\\\thing\doodad\\';
$linearray = split('\\\\', $line); //<--NOTE USE OF FOUR(4)backslashes
print join(":", $linearray);
?>
</pre>
==================================
output is:
<pre>
stuff::thing:doodad:
</pre>
ramkumar rajendran ¶
19 years ago
A correction to a earlier note
If you want to use split to check on line feeds (\n), the following won't work:
$line = split("\n", $input_several_lines_long);
You really have to do this instead, notice the second slash:
$line = split("/\n", $input_several_lines_long);
Took me a little while to figure to do
franz at fholzinger dot com ¶
19 years ago
The example from ramkumar rajendran did not work.
$line = split("/\n", $input_several_lines_long);
I do not know why this does not work for me.
The following has worked for me to get a maximum of 2 array parts separated by the first new line (independant if saved under UNIX or WINDOWS):
$line = preg_split('/[\n\r]+/',$input_several_lines_long,2);
Also empty lines are not considered here.
krahn at niehs dot nih dot gov ¶
21 years ago
> strange things happen with split
> this didn't work
> $vontag $vonmonat were empty strings
...
> list ($vontag , $vonmonat) = split ('.' , $fromdate); // << bad
Split is acting exactly as it should; it splits on regular expressions.
A period is a regular expression pattern for a single character.
So, an actual period must be escaped with a backslash: '\.'
A period within brackets is not an any-character pattern, because it does
not make sense in that context.
Beware that regular expressions can be confusing becuase there
are a few different varieties of patterns.
jchart at sdccu dot net ¶
22 years ago
[Ed. note: Close. The pipe *is* an operator in PHP, but
the reason this fails is because it's also an operator
in the regex syntax. The distinction here is important
since a PHP operator inside a string is just a character.]
The reason your code:
$line = "12|3|Fred";
list ($msgid, $msgref, $msgtopic)=split('|', $line);
didn't work is because the "|" symbol is an operator in PHP. If you want to use the pipe symbol as a delimiter you must excape it with a back slash, "\|". You code should look like this:
$line = "12|3|Fred";
list ($msgid, $msgref, $msgtopic)=split('\|', $line);
Jort ¶
17 years ago
If you are looking for EITHER open square brackets OR close square brackets, then '[[]]' won't work (reasonably expected), but neither will '[\[\]]', nor with any number of escapes. HOWEVER, if your pattern is '[][]' it will work.
mcgarry at tig dot com dot au ¶
22 years ago
split() doesn't like NUL characters within the string, it treats the first one it meets as the end of the string, so if you have data you want to split that can contain a NUL character you'll need to convert it into something else first, eg:
$line=str_replace(chr(0),'',$line);
Chris Tyler ¶
16 years ago
Thank you Dave for your code below. Here is one change I made to avoid a redundant quote at the end of some lines (at least when I used excel:
Added another --length; into the if statement below:
// Is the last thing a quote?
if ($trim_quote){
// Well then get rid of it
--$length;
// ADD TO FIX extra quote
--$length;
}
robin at teddyb dot org ¶
19 years ago
wchris's quotesplit assumes that anything that is quoted must also be a complete delimiter-seperated entry by itself. This version does not. It also uses split's argument order.
function quotesplit( $splitter=',', $s )
{
//First step is to split it up into the bits that are surrounded by quotes
//and the bits that aren't. Adding the delimiter to the ends simplifies
//the logic further down
$getstrings = explode('"', $splitter.$s.$splitter);
//$instring toggles so we know if we are in a quoted string or not
$delimlen = strlen($splitter);
$instring = 0;
while (list($arg, $val) = each($getstrings))
{
if ($instring==1)
{
//Add the whole string, untouched to the previous value in the array
$result[count($result)-1] = $result[count($result)-1].$val;
$instring = 0;
}
else
{
//Break up the string according to the delimiter character
//Each string has extraneous delimiters around it (inc the ones we added
//above), so they need to be stripped off
$temparray = split($splitter, substr($val, $delimlen, strlen($val)-$delimlen-$delimlen+1 ) );
while(list($iarg, $ival) = each($temparray))
{
$result[] = trim($ival);
}
$instring = 1;
}
}
return $result;
}
claes at dot2me.com ¶
20 years ago
Though this is obvious, the manual is a bit incorrect when claiming that the return will always be 1+number of time the split pattern occures. If the split pattern is the first part of the string, the return will still be 1. E.g.
$a = split("zz," "zzxsj.com");
count($a);
=> 1.
The return of this can not in anyway be seperated from the return where the split pattern is not found.
fotw at gmx dot net ¶
22 years ago
Ups! It seems that neither explode nor split REALY takes a STRING but only a single character as a string for splitting the string.
I found this problem in one of my codes when trying to split a string using ";\n" as breaking string. The result, only ";" was thaken... the rest of the string was ignored.
Same when I tried to substitute "\n" by any other thing. :(
pascalaschwandenNOSPAM at gmail dot com ¶
16 years ago
The following code will mimick the explode functionality: explode( " ", $s ); The difference, of course, is that the split method takes a regular expression instead of a string.
$s = "Split this sentence by spaces";
$words = split("[ ]+", $s);
print_r($words);
Output:
Array
(
[0] => Split
[1] => this
[2] => sentence
[3] => by
[4] => spaces
)
http://www.codesplunk.com/nr/questions/php12.html
alphibia at alphibia dot com ¶
20 years ago
I'd like to correct myself, I found that after testing my last solution it will create 5 lines no matter what... So I added this to make sure that it only displays 5 if there are five newlines. :-)
<?php
$MaxNewLines = 5;
$BRCount = substr_count($Message, '<br />');
if ($BRCount<$MaxNewLines)
$MaxNewLines=$BRCount;
else if($BRCount == 0)
$MaxNewLines=1;
$Message = str_replace(chr(13), "<br />", $Message);
$MessageArray = split("<br />", $Message, $MaxNewLines);
$Message = ""; $u=0;
do {
$Message.=$MessageArray[$u].'<br />';
$u++;
} while($u<($MaxNewLines-1));
$Message.=str_replace("<br />"," ",$MessageArray[$u]);
?>
-Tim
http://www.alphibia.com
lewis [ at t] hcoms [d dot t] co [d dot t] uk ¶
16 years ago
Those of you trying to use split for CSV, it won't always work as expected. Instead, try using a simple stack method:
<?php
/**
* Create a 2D array from a CSV string
*
* @param mixed $data 2D array
* @param string $delimiter Field delimiter
* @param string $enclosure Field enclosure
* @param string $newline Line seperator
* @return
*/
function parse($data, $delimiter = ',', $enclosure = '"', $newline = "\n"){
$pos = $last_pos = -1;
$end = strlen($data);
$row = 0;
$quote_open = false;
$trim_quote = false;
$return = array();
// Create a continuous loop
for ($i = -1;; ++$i){
++$pos;
// Get the positions
$comma_pos = strpos($data, $delimiter, $pos);
$quote_pos = strpos($data, $enclosure, $pos);
$newline_pos = strpos($data, $newline, $pos);
// Which one comes first?
$pos = min(($comma_pos === false) ? $end : $comma_pos, ($quote_pos === false) ? $end : $quote_pos, ($newline_pos === false) ? $end : $newline_pos);
// Cache it
$char = (isset($data[$pos])) ? $data[$pos] : null;
$done = ($pos == $end);
// It it a special character?
if ($done || $char == $delimiter || $char == $newline){
// Ignore it as we're still in a quote
if ($quote_open && !$done){
continue;
}
$length = $pos - ++$last_pos;
// Is the last thing a quote?
if ($trim_quote){
// Well then get rid of it
--$length;
}
// Get all the contents of this column
$return[$row][] = ($length > 0) ? str_replace($enclosure . $enclosure, $enclosure, substr($data, $last_pos, $length)) : '';
// And we're done
if ($done){
break;
}
// Save the last position
$last_pos = $pos;
// Next row?
if ($char == $newline){
++$row;
}
$trim_quote = false;
}
// Our quote?
else if ($char == $enclosure){
// Toggle it
if ($quote_open == false){
// It's an opening quote
$quote_open = true;
$trim_quote = false;
// Trim this opening quote?
if ($last_pos + 1 == $pos){
++$last_pos;
}
}
else {
// It's a closing quote
$quote_open = false;
// Trim the last quote?
$trim_quote = true;
}
}
}
return $return;
}
?>
This *should* work for any valid CSV string, regardless of what it contains inside its quotes (using RFC 4180). It should also be faster than most of the others I've seen. It's very simple in concept, and thoroughly commented.
not at anythingspecial dot com ¶
22 years ago
If you need to do a split on a period make sure you escape the period out..
$ext_arr = split("\.","something.jpg");
... because
$ext_arr = split(".","something.jpg"); won't work properly.
robin at teddyb dot org ¶
19 years ago
Actually, this version is better than the last I submitted. The goal here is to be able to engage in *multiple* delimeter removal passes; for all but the last pass, set the third value to "1", and everything should go well.
function quotesplit( $splitter=',', $s, $restore_quotes=0 )
{
//First step is to split it up into the bits that are surrounded by quotes
//and the bits that aren't. Adding the delimiter to the ends simplifies
//the logic further down
$getstrings = explode('"', $splitter.$s.$splitter);
//$instring toggles so we know if we are in a quoted string or not
$delimlen = strlen($splitter);
$instring = 0;
while (list($arg, $val) = each($getstrings))
{
if ($instring==1)
{
if( $restore_quotes )
{
//Add the whole string, untouched to the previous value in the array
$result[count($result)-1] = $result[count($result)-1].'"'.$val.'"';
} else {
//Add the whole string, untouched to the array
$result[] = $val;
}
$instring = 0;
}
else
{
//Break up the string according to the delimiter character
//Each string has extraneous delimiters around it (inc the ones we added
//above), so they need to be stripped off
$temparray = split($splitter, substr($val, $delimlen, strlen($val)-$delimlen-$delimlen+1 ) );
while(list($iarg, $ival) = each($temparray))
{
$result[] = trim($ival);
}
$instring = 1;
}
}
return $result;
}
Mike ¶
17 years ago
// Split a string into words on boundaries of one or more spaces, tabs or new-lines
$s = "Please cut \t me \n in pieces";
$words = split("[\n\r\t ]+", $s);
print_r($words);
// Output:
Array
(
[0] => Please
[1] => cut
[2] => me
[3] => in
[4] => pieces
)
Greg Levine ¶
16 years ago
I kept running into the same issue Chris Tyler experienced with lewis [ at t] hcoms [d dot t] co [d dot t] uk's function before realizing that Chris had come up with a solution. However, that solution was just a little off it seems, unless your CSV only contains one line.
If you simply add another --length; in the place you suggested, then the function will always trim the last two characters on the line. Since the newline character is the last character on the line and the redundant quote (or other enclosure) is the second to last character, this works for the final segment. But when parsing segments that do not include a newline character, you end up trimming the redundant enclosure and the last character before the enclosure.
For example,
"he","she","him","her"\r\n
becomes
[0] => h
[1] => sh
[2] => hi
[3] => her
Since the segment could end with the enclosure (i.e., ") or the enclosure followed by the newline (i.e., "\r\n), you have make sure you are only adding another --length; when the latter is the case. Replacing the code block that you suggested with the following will do the trick.
# Is the last thing a newline?
if( $char == $newline )
{
# Well then get rid of it
--$length;
}
# Is the last thing a quote?
if( $trim_quote )
{
# Well then get rid of it
--$length;
}
I've tested this only for the purposes of the script I'm working on at this time. So, there could be other bugs I haven't come across, but this seems like the easiest way to eliminate the redundant enclosure.
kang at elpmis dot com ¶
22 years ago
This is a good way to display a comma delimited file with two columns. The first column is the URL's description, the second is the actual URL.
<ul>
<?php
$fname="relatedlinks.csv";
$fp=fopen($fname,"r") or die("Error found.");
$line = fgets( $fp, 1024 );
while(!feof($fp))
{
list($desc,$url,$dummy) = split( ",", $line, 3 );
print "<li>";
print "<a href='$url'>$desc</a>";
print "</li>\n";
$line = fgets( $fp, 1024 );
}
fclose($fp);
?>
</ul>
