Mr Chris Posted April 24, 2006 Share Posted April 24, 2006 Hi Guys, Quick one. I'm uploading a tab-delimited file to a mysql database and the tab delimited file derives from an excel file. In these Excel cells some of them have a comma (,) in. Now when I save the excel file as tab delimited it now puts quotes around the values that have commas in the cell? Any idea how I can stop this happening? Thanks Chris Link to comment https://forums.phpfreaks.com/topic/8260-tab-delimited-file-issues/ Share on other sites More sharing options...
fenway Posted April 24, 2006 Share Posted April 24, 2006 Yeah, Excel's dumb that way. It quotes fields that have the comma in it even if you're not outputting a comma-separated file! You can just handle this on the way it. Link to comment https://forums.phpfreaks.com/topic/8260-tab-delimited-file-issues/#findComment-30184 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.