PHP Classes

Incorrect handling of Excel CSV

Recommend this page to a friend!

      CSV Tokenizer  >  All threads  >  Incorrect handling of Excel CSV  >  (Un) Subscribe thread alerts  
Subject:Incorrect handling of Excel CSV
Summary:Excel CSV outputs a string enclosed in double quotes
Messages:1
Author:John Torr
Date:2006-04-19 06:37:38
 

  1. Incorrect handling of Excel CSV   Reply   Report abuse  
Picture of John Torr John Torr - 2006-04-19 06:37:38
When Excel saves as CSV it used comma seperated CSV fields.

If any field happens to have a comma in it then the entire field is enclosed in double quotes "

This class does not recognize this and splits the field based on the delimiting character within the field thus breaking a field into smaller parts.