Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting xls to ofx | Excel Discussion (Misc queries) | |||
Converting a date to a text field w/o converting it to a julian da | Excel Worksheet Functions | |||
converting to Kg | Excel Discussion (Misc queries) | |||
Converting USD$ to AUD$ | Excel Worksheet Functions | |||
Converting .XLS to .XML | Excel Discussion (Misc queries) |