ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   PHP's fgetcsv converting ¿0a to \n ? (https://www.excelbanter.com/excel-programming/349990-phps-fgetcsv-converting-%BF0a-%5Cn.html)

anjanesh

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



All times are GMT +1. The time now is 10:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com