double quotes around text fields in .txt

Hi,

I have a very big import to do from Excel 2002 to a .txt file. I need
double quotes around all text fields, but I get everything but. Can
someone pleeeese tell me how to do this.

Do I need the format of the fields to be general or text? Do I start
with single quotes, double quotes, no quotes or maybe even two single
quotes? I've tried everything I can think of.

I even tried going through a .csv file, but then I get three double
quotes!

Thanks a bunch,

Michele

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

He supports lots of options.

[email protected] wrote:
>
> Hi,
>
> I have a very big import to do from Excel 2002 to a .txt file. I need
> double quotes around all text fields, but I get everything but. Can
> someone pleeeese tell me how to do this.
>
> Do I need the format of the fields to be general or text? Do I start
> with single quotes, double quotes, no quotes or maybe even two single
> quotes? I've tried everything I can think of.
>
> I even tried going through a .csv file, but then I get three double
> quotes!
>
> Thanks a bunch,
>
> Michele

--

Dave Peterson

Thanks Dave, but the application still didn't help. I need it to tell
the difference between text (or general) and number fields. The
application will put double quotes around all fields or none.

For example, it has to end up looking like this in a .txt file:
"19","big product",89,45,0,"description1"
"20","another product",45,23,5,"description2"

Good information though. Any other ideas?

Take care,

Michele

Maybe you can make a formula and put it in an adjacent cell:

=""""&A1&"""" & "," & """" & B1 & """" & "," & C1 & "," & D1 (and so forth)

or
=""""&A2&""","""&B2&""","&C2&","&D2

or when you start seeing double quotes in your sleep:

=CHAR(34)&A2&CHAR(34)& "," & CHAR(34)&B2&CHAR(34) &","&C2&","&D2


Then drag your formula down
copy that column and paste to Notepad
Save the file from notepad.




[email protected] wrote:
>
> Thanks Dave, but the application still didn't help. I need it to tell
> the difference between text (or general) and number fields. The
> application will put double quotes around all fields or none.
>
> For example, it has to end up looking like this in a .txt file:
> "19","big product",89,45,0,"description1"
> "20","another product",45,23,5,"description2"
>
> Good information though. Any other ideas?
>
> Take care,
>
> Michele

--

Dave Peterson

Thanks Dave! Once again, you are my God.