Problems with text files from a Mac
| From: | Sterling Anderson | Date: | Fri, 13 Dec 2002 02:22:40 +0000 |
| Subject: | Problems with text files from a Mac | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-128163@lists.php.net to get a copy of this message | ||
I am working on an application for a school district and am having some problems with the files they are supplying for import.
They are supplying data files and I am writing routines to populate the database using these files. Its a simple file upload then I just need to parse through the tab separated value file. I am using the most recent PHP build on Windows with IIS ISAPI and a MSSQL database. They are sending text files from a Macintosh application.
I noticed on the documentation for fgetcsv() that it cannot read the end of line character on Mac files. I have not been able to find a good work around for this issue. When I grab the entire contents of the file then try doing a string replacement on the "\r" or even "\t" for that matter it does not work.
Has anyone found a good solution for dealing with Mac files?