Bug with Excel 2003 saving as Tab Delimmited Text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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'

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
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
 
Not using tab delimiters I'm afraid

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
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.
 
Wahab

What about fixed width?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
Back
Top