double quotes when saving to a text file

G

Gaijin

Board Regular

Joined

Jul 21, 2002

Messages

56

• Apr 23, 2003

• #2

Just bumping this back up

 

Upvote 0

Joe4

MrExcel MVP, Junior Admin

Joined

Aug 1, 2002

Messages

72,265

Office Version

1. 365

Platform

1. Windows

• Apr 23, 2003

• #3

I think it has to do with the text format you are saving it to. If you are saving to a comma separated text file, I think it will put in the double quotes to differentiate actual commas (like in names) with the separators.

I believe if you save it to a different text option, like fixed width text, it might not insert the quotes.

If you need the commas, one workaround is to "build" the text string on a different sheet in just one column, inserting commas between your fields, and then saving as a fixed width text file.

 

Upvote 0

Mark O'Brien

MrExcel MVP

Joined

Feb 15, 2002

Messages

3,530

• Apr 23, 2003

• #4

I have done this before, but I can't remember off-hand what setting you need to use. Could you post the relevant part of your code here? This will minimise the time required to provide the fix for you.

Thanks

 

Upvote 0

Joe4

MrExcel MVP, Junior Admin

Joined

Aug 1, 2002

Messages

72,265

Office Version

1. 365

Platform

1. Windows

• Apr 23, 2003

• #5

Another option is if you have a good text editor, like Ultra Edit, you can do a Search and Replace on the text file, replacing the quotes with nothing.

 

Upvote 0

G

Gaijin

Board Regular

Joined

Jul 21, 2002

Messages

56

• Apr 23, 2003

• #6

Insert into Orders (ord_id, name, order_amt) values ('10','Name','order_amt');

There is an example of the statement in A1, but when you save it as any of the txt file formats it puts quotes around each cell

Thank you for your help

Gaijin

 

Upvote 0

M

Mark W.

MrExcel MVP

Joined

Feb 10, 2002

Messages

11,654

• Apr 23, 2003

• #7

Have you considered saving as .prn?

 

Upvote 0

Mark O'Brien

MrExcel MVP

Joined

Feb 15, 2002

Messages

3,530

• Apr 23, 2003

• #8

OK, I thought you were using VBA to accomplish this. There are some tricky settings that can throw things off there. Anyway, the simple solution is to save your file as a "Formatted Text (space delimited) *.prn)" file.

EDIT:: Bugger

 

Upvote 0

G

Gaijin

Board Regular

Joined

Jul 21, 2002

Messages

56

• Apr 23, 2003

• #9

As always Mrexcel comes though again. I appreciate all your imput.

 

Upvote 0

Y

yesterday

New Member

Joined

Mar 5, 2003

Messages

34

• Apr 23, 2003

• #10

This thread was incredibly timely since I had the same question too.

I AM creating the text file from VBA, however. Actually, I should say it's an ASCII file. I needed to save my new file with a specific suffix used by a stats package. Trouble was, Excel would insist on adding a .prn suffix so that my file would end up something like "myfile.ex.prn".

Easy enough to fix with VBA, though. I just went into the ActiveWorkbook.SaveAs command and fixed it there.

Thanks guys!

 

Upvote 0