#33179 [NEW]: backslash is not an escape character in correct CSV
| From: | fsb at thefsb dot org | Date: | Mon, 30 May 2005 00:23:13 +0000 |
| Subject: | #33179 [NEW]: backslash is not an escape character in correct CSV | ||
| Groups: | php.bugs | ||
| Request: | Send a blank email to php-bugs+get-79675@lists.php.net to get a copy of this message | ||
From: fsb at thefsb dot org
Operating system: os x 10.3 and freebsd 5.3
PHP version: 4.3.10
PHP Bug Type: Filesystem function related
Bug description: backslash is not an escape character in correct CSV
Description:
------------
why can i have a \ at the end of a field but not
if i wrap it in " field delimiters? e.g.
abc,123\,abc works fine but
"abc","123\",abc produces only two columns
this question has been asked before (#29278, #30476,
etc.) and iliaa@php.net rejects the bug as bogus. i
don't agree.
if this is not a bug then this unusual use of \ to
escape only closing field delimiting double quotes
but not escape any other instances of double qotes or
(it would appear) any other character SHOULD be
documented. it is not.
moreover this undocumented feature is not consistent
with the specification of the CSV file format found
here: http://www.creativyst.com/Doc/Articles/CSV/
CSV01.htm
this csv spec suggests that backslash has no special
meaning in the CSV format at all. indeed, in all my
tests, fgetcsv appears to accord it no special meaning
_except_ in this one particular case.
such a surprising behaviour that deviates from common
CSV file format conventions SHOULD be documented (or
corrected).
--
Edit bug report at http://bugs.php.net/?id=33179&edit=1
--
Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=33179&r=trysnapshot4
Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=33179&r=trysnapshot50
Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=33179&r=trysnapshot51
Fixed in CVS: http://bugs.php.net/fix.php?id=33179&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=33179&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=33179&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=33179&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=33179&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=33179&r=support
Expected behavior: http://bugs.php.net/fix.php?id=33179&r=notwrong
Not enough info: http://bugs.php.net/fix.php?id=33179&r=notenoughinfo
Submitted twice: http://bugs.php.net/fix.php?id=33179&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=33179&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=33179&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=33179&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=33179&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=33179&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=33179&r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=33179&r=nozend
MySQL Configuration Error: http://bugs.php.net/fix.php?id=33179&r=mysqlcfg