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 Quote Link to comment 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.