What file format that includes quotes and comma as delimiters?
 

The resulting file will be like:

"text", "text1", "text3"

What file format that includes quotes and comma as delimiters?
 

CSV format

On Thu, 21 Oct 2004 01:39:02 -0700, Angelo
wrote:

The resulting file will be like:

"text", "text1", "text3"

What file format that includes quotes and comma as delimiters?
 

If you want all your text strings to be in double quotes, the CSV won't do
that. You have to use a macro:

http://support.microsoft.com/default...b;en-us;291296
XL2002: Procedure to Export a Text File with Both Comma and Quote Delimiters

http://support.microsoft.com/default...b;en-us;213448
XL2000: Procedure to Export a Text File with Both Comma and Quote Delimiters

http://support.microsoft.com/default...b;en-us;123183
How to export data to a text file with comma and quote delimiter in Excel

CSV will just quote text strings that contain the delimiter.

--
Regards,
Tom Ogilvy

"Angelo" wrote in message
...
The resulting file will be like:

"text", "text1", "text3"

What file format that includes quotes and comma as delimiters?
 

Here are three sites that you could steal some code from:

Earl Kiosterud's Text Write program:
www.smokeylake.com/excel
(or directly: http://www.smokeylake.com/excel/text_write_program.htm)

Chip Pearson's:
http://www.cpearson.com/excel/imptext.htm

J.E. McGimpsey's:
http://www.mcgimpsey.com/excel/textfiles.html

(You may be happy with Earl's version--right out of the box!)

Angelo wrote:

The resulting file will be like:

"text", "text1", "text3"

--

Dave Peterson

What file format that includes quotes and comma as delimiters?
 

I haven't look at Earl or JE's, but Chip's doesn't do what he asked.

--
Regards,
Tom Ogilvy


"Dave Peterson" wrote in message
...
Here are three sites that you could steal some code from:

Earl Kiosterud's Text Write program:
www.smokeylake.com/excel
(or directly: http://www.smokeylake.com/excel/text_write_program.htm)

Chip Pearson's:
http://www.cpearson.com/excel/imptext.htm

J.E. McGimpsey's:
http://www.mcgimpsey.com/excel/textfiles.html

(You may be happy with Earl's version--right out of the box!)

Angelo wrote:

The resulting file will be like:

"text", "text1", "text3"

--

Dave Peterson

What file format that includes quotes and comma as delimiters?
 

I meant as a get started--not as a final product.

But IIRC, Earl has a worksheet of options that includes this feature.



Tom Ogilvy wrote:

I haven't look at Earl or JE's, but Chip's doesn't do what he asked.

--
Regards,
Tom Ogilvy

"Dave Peterson" wrote in message
...
Here are three sites that you could steal some code from:

Earl Kiosterud's Text Write program:
www.smokeylake.com/excel
(or directly: http://www.smokeylake.com/excel/text_write_program.htm)

Chip Pearson's:
http://www.cpearson.com/excel/imptext.htm

J.E. McGimpsey's:
http://www.mcgimpsey.com/excel/textfiles.html

(You may be happy with Earl's version--right out of the box!)

Angelo wrote:

The resulting file will be like:

"text", "text1", "text3"

--

Dave Peterson


--

Dave Peterson