Re: Spreadsheet_Excel_Reader problem
| From: | Mattias Thorslund | Date: | Thu, 18 Mar 2010 16:16:30 +0000 |
| Subject: | Re: Spreadsheet_Excel_Reader problem | ||
| References: | 1 2 3 4 5 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-302969@lists.php.net to get a copy of this message | ||
Paul M Foster wrote:
I process a lot of CSV files, and what I typically see is that Excel will enclose fields which might contain commas in quotes. This gets messy. So I finally wrote a C utility which parses the file and yields tab-delimited records without the quotes. PaulAnd fgetcsv() didn't work for you? http://www.php.net/fgetcsv Cheers, Mattias