Convert excel (.xls) to tab delimited (.txt) without double quotat
Yes, but it involves another step outside of Excel. When you select
tab-delimited, that is the behavior you get.
As soon as you save your file, open it in NotePad or EditPad (an even more
robust notepad program) and do a Search/Replace.
Ctrl-H usually brings up the window.
Search: ","
Replace: ,
Replace All
Then save the document again.
Will this work for you?
--
"Actually, I AM a rocket scientist." -- JB
Your feedback is appreciated, click YES if this post helped you.
"Andrea" wrote:
When converting my excel spreadsheet to tab delimited, I get double quotation
marks around anything that has a comma. This is making the datafeed in my
website appear unclean. Is there any way around this?
--
Andrea
|