Solved

Dumping Excel file to txt file adding double quotes

Posted on 2011-09-20
4
294 Views
Last Modified: 2012-05-12
I have an excel file that I am saving as a txt (tab delinmited) file for import into another system.  Everytime I save to txt, it is adding double quotes in front of every line in the txt file.  I can see them when I open in notepad.  How can I change the xlsx file it so that it doesn't do that?  Help, please!

Sample of the Excel data attached
Test.xlsx
0
Comment
Question by:timoteoga
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 25

Expert Comment

by:Ron Malmstead
ID: 36569224
The quotes are there to help distinguish the field data.
I'm not sure if there is a way to turn it off...but why not just do a find/replace in notepad to remove all the double quotes?
0
 
LVL 25

Expert Comment

by:Ron Malmstead
ID: 36569248
Another thing you can do, is select all the data you want.... copy/paste into notepad and it will be Tab delimited by default, without quotes...
0
 
LVL 92

Accepted Solution

by:
Patrick Matthews earned 500 total points
ID: 36569264
One of your columns has a comma in it.  By default, Excel will want to use doublequotes as a text qualifier because of that.

When I removed all commas via find/replace and then saved as a tab delimited txt file, I got no text qualifiers.
0
 
LVL 7

Expert Comment

by:mmaris
ID: 36569277
In the following thread, the people resolved the issue with simple code:

Sub exportdata()
 Cells.Select
 Selection.Copy
 Shell "notepad.exe", vbNormalFocus
 SendKeys "^V"
 SendKeys "%fa"
 End Sub

http://www.ozgrid.com/forum/showthread.php?t=18333&page=1

0

Featured Post

Enroll in May's Course of the Month

May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question