Solved

Dumping Excel file to txt file adding double quotes

Posted on 2011-09-20
4
285 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
  • 2
4 Comments
 
LVL 25

Expert Comment

by:Ron M
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 M
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

757 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now