Problems with text files from a Mac

From: 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?

« previous php.general (#128163) next »