 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Excel Errors / January 2005Bug with Excel 2003 saving as Tab Delimmited Text
Excel 2003 has the ability to save a tab delimited text file. Everything in that regard works properly except when a certain cell has some text that contains commas, for example, if cell A1 contains "BLAH" and A2 contains "A, B, C", then saving as a tab delimited text does not work as required. Saving as tab delimitted text creates a text file containing the following BLAH "A, B, C" Note that the second cell has qoutation marks created for it. Actually saving this excel file as a tab delimitted text file should generate the following content (without the qoutation marks). BLAH A, B, C Please fix that. Wahab Firstly if you aim is to inform MS then you should realise that they do not 'officially monitor these groups. What Excel is doing is putting in a 'text qualifier' to avoid issues of the commas being seen as delimiters on a future import. In most of their import routines you can specify the reverse to take these double quotes out...doesn't help if it's not MS your importing into. You could use 'space delimited, which does not have this 'feature'  SignatureHTH Nick Hodge Microsoft MVP - Excel Southampton, England nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS > Excel 2003 has the ability to save a tab delimited text file. Everything > in [quoted text clipped - 14 lines] > > Please fix that. Well, Thanks Nick. I already informed MS about this issue prior to posting this post, but they suggested posting it here just in case it is needed. Anyway, yes, I am NOT importing to microsoft, I am using another inhouse product to do the import. My question is, is it possible to save these files without the "text-qualifiers"? Is there an option that I can specify so it saves this file the way I need it? Thanks. -Wahab > Wahab > [quoted text clipped - 26 lines] > > > > Please fix that. Not using tab delimiters I'm afraid SignatureHTH Nick Hodge Microsoft MVP - Excel Southampton, England nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS > Well, Thanks Nick. > [quoted text clipped - 49 lines] >> > >> > Please fix that. Is there any way (other than tab, space or comma delimitted) that I can save without having qoutations? Basically, the cells that I have contain spaces (thus space delimitted is not good for me), they contain commas (comma delimitted is not good), but do not contain tabs, but I do not want the place holders get created as described below. > Not using tab delimiters I'm afraid > [quoted text clipped - 51 lines] > >> > > >> > Please fix that. Wahab What about fixed width? SignatureHTH Nick Hodge Microsoft MVP - Excel Southampton, England nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS > Is there any way (other than tab, space or comma delimitted) that I can > save [quoted text clipped - 65 lines] >> >> > >> >> > Please fix that. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.