csvFixDbquotes.php

<?php
	function tai_csvFixDbquotes( $csv, $delimiter = ',', $enclosure = '"' )
	{
		$res = '';
		if( $csv[ strlen($csv)-1 ] == "\r" )
			$csv = substr($csv,0,-1);
		$inDbquotes = false;
		if( strlen($csv)==0 || $csv[0] != $enclosure )
			$res .= $enclosure;
		for( $i=0; $i<strlen($csv); $i++ )
		{
			if( $csv[$i] == $enclosure )
				$inDbquotes = !$inDbquotes;
			if( $csv[$i] == $delimiter && !$inDbquotes )
			{
				if( $i-1<0 || $csv[$i-1] != $enclosure )
					$res .= $enclosure;
				$res .= $delimiter;
				if( $i+1 >= strlen($csv) || $csv[$i+1] != $enclosure )
					$res .= $enclosure;
			}
			else $res .= $csv[$i];
		}
		if( strlen($csv)==0 || $csv[strlen($csv)-1] != $enclosure )
			$res .= $enclosure;
		return $res;
	}
/*
echo tai_csvFixDbquotes('測試,測試').'<br />';
echo tai_csvFixDbquotes('"測試","測試"').'<br />';
echo tai_csvFixDbquotes('"測試",測試,"測試"').'<br />';
echo tai_csvFixDbquotes('測試測試').'<br />';
echo tai_csvFixDbquotes('123,456').'<br />';
echo tai_csvFixDbquotes('').'<br />';
*/
?>