Jump to content


Photo

tab-delimited file issues


  • Please log in to reply
1 reply to this topic

#1 Mr Chris

Mr Chris
  • Members
  • PipPipPip
  • Advanced Member
  • 336 posts

Posted 24 April 2006 - 02:45 PM

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

#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 24 April 2006 - 05:26 PM

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.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users