Jump to content

Archived

This topic is now archived and is closed to further replies.

Mr Chris

tab-delimited file issues

Recommended Posts

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

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.