Excel2000-Remove a column of data in a txt file

[marka2005]

This may seem simple but for some reason I can't get it right.

I have a txt file that looks like this.

"aa","bbb","cccc","dddddd"
"aa","bbb","cccc","dddddd"
"aa","bbb","cccc","dddddd"
"aa","bbb","cccc","dddddd"
"aa","bbb","cccc","dddddd"
"aa","bbb","cccc","dddddd"

I would like the txt file to now contain only this:

"aa","cccc","dddddd"
"aa","cccc","dddddd"
"aa","cccc","dddddd"
"aa","cccc","dddddd"
"aa","cccc","dddddd"
"aa","cccc","dddddd"

I have tried importing the original txt file. Remove the column "b" and
then save as a csv but I end up with something like this:

''"aa''",''"cccc''",''"dddddd"''
''"aa''",''"cccc''",''"dddddd"''
''"aa''",''"cccc''",''"dddddd"''
''"aa''",''"cccc''",''"dddddd"''

Or I end up with spaces between each column.


What the heck am I doing wrong here?

Thanks for your help.

 

[Richard.Toren]

Subject: Re: Excel2000-Remove a column of data in a txt file


Have excel remove the quotation marks when it imports the original csv file
-----Original Message-----

 

[Dave Peterson]

Maybe you could use a macro that wrote the data the way you want.

Earl Kiosterud's Text Write program:
www.smokeylake.com/excel
(or directly: http://www.smokeylake.com/excel/text_write_program.htm)

Chip Pearson's:
http://www.cpearson.com/excel/imptext.htm

J.E. McGimpsey's:
http://www.mcgimpsey.com/excel/textfiles.html

Another option is to use a helper column:
=""""&A1&""","""&B1&""","""&C1&""""
and drag down the column.
Then copy that column to NotePad and save your text file from there.