View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
anjanesh anjanesh is offline
external usenet poster
 
Posts: 1
Default PHP's fgetcsv converting ¿0a to \n ?


Hi

PHP's 'fgetcsv' (http://us3.php.net/manual/en/function.fgetcsv.php) can
read a line (one row) from a csv file and return the column values.

When converting xls to csv in MS Excel, page-breaks are converted to
*¿0a¿0a* in the csv file.

I had this in my php code
Formula:
--------------------
$data = str_replace("¿0a", "\\n", $data);
--------------------
but I find that if this line is not there, even then *¿0a* is treated
as a new-line. Would like to know if php's function doing this or
something else ?

Thanks


--
anjanesh

Freelance Developer
------------------------------------------------------------------------
anjanesh's Profile: http://www.excelforum.com/member.php...o&userid=27132
View this thread: http://www.excelforum.com/showthread...hreadid=499706