• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Preventing Double Quotation Marks When Saving Excel Sheet As Text

I

indi visual

Member
With the text below, when I save as a text file from Excel it adds extra quotation marks.


Before:

<html xmlns="http://www.w3.org/1999/xhtml">


After:

"<html xmlns=""http://www.w3.org/1999/xhtml"">"


I could use search and replace afterward, but it would be quite a few files to revise so I was hoping someone had a quick fix answer.


Any advice would be super.
 
I usually copy paste the values in to notepad ++ and then save it as text. Sometimes when the cells have linebreaks in them this method also fails.


Then, I replace all char(10)s with empty spaces. like =substitute(a1,char(10),""). This solves the extra quotation problem for me.
 
Forgive me, I'm not sure what you mean by pasting the values in notepad or how to use the formula?


What I'm doing is importing the data as text in to Excel using the wizard, then modifying the text a bit (a few swap outs of text here and there), and then I save it as a text file again.


The text I'm importing does have line breaks, but the quotations don't always appear everywhere I have line breaks (which boggles the mind even more).


When I open up the text file all is dandy except for the extra quotation marks.


I hope this clears up my position on my intention.
 
I don't know dude, but my guess is that you're using excel for something that you probably shouldn't.
 
It's actually pretty neat.


I'm using it to stack and modify a ridiculous amount text (code) in seconds.


Thousands of uniquely modified lines of code in under 10 seconds is a pretty sweet deal.


I can modify thousands of lines of unique code in one sheet by importing alternate row text where necessary.


First, I import the code(which is close to 300,000 rows!) in Excel.


Next, I break the text up at a specified line break point throughout all of the rows to it's own new sheet.


Then, I extract the individual sheets to *.txt, *.html, or *.xml (whatever I need).


Finally, I have a folder with thousands of perfectly edited saved files in minutes (although I do rename the files themselves with another program -but that takes seconds too).


Only problem are the blasted double quotations I get in the text files.


Side Note: I have a program that will remove the unwanted double quotations from all of the thousands of files at once, but all in all it's an extra program I have to open up that I would preferably like to avoid if all possible.


As far as what Excel is used for?... Umm.. well let's just say I'm the guy that eats cereal out of a cup ; )
 
You must log in or register to reply here.
Back
Top