TalkPHP - View Single Post - Importing comma-delimited csv file, containing commas

Dave · 10-30-2009, 02:48 PM

Here are a few lines below. Only 2 fields: a name field and an ID field. As you can see, the name field contains commas. When the program reads the CSV file, it generates a third field because it "thinks" that the comma within the name field is a field separator.

Thanks!

PHP Code:


			
/*



Wiley, Jimmie    963144

Johnson, Michelle    1009959

Lynn, Kenya    1183526

Johnson, Gregory    1189881

Dixon, Kendric    1189915



*/

10-30-2009, 02:48 PM	#8 (permalink)
Dave The Acquainted Join Date: Apr 2008 Posts: 110 Thanks: 97	Here are a few lines below. Only 2 fields: a name field and an ID field. As you can see, the name field contains commas. When the program reads the CSV file, it generates a third field because it "thinks" that the comma within the name field is a field separator. Thanks! PHP Code: `/* Wiley, Jimmie 963144 Johnson, Michelle 1009959 Lynn, Kenya 1183526 Johnson, Gregory 1189881 Dixon, Kendric 1189915 */`