ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Quotation marks in a string (https://www.excelbanter.com/excel-programming/417475-quotation-marks-string.html)

Fabian Grodek

Quotation marks in a string
 
Hi,
I want to run a macro that writes out to a text file the following string:
<gamma unit="DEG" 0.0 </gamma

I've tried the following method:
Write #1, "<gamma unit=""DEG"" 0.0 </gamma"

But then I get exactly that:
"<gamma unit=""DEG"" 0.0 </gamma"

Of course, I don't want the double quotation marks, but only once (i.e.,
"DEG", not ""DEG"").

Any hint will be greatly appreciated.
Fabian

Fabian Grodek

Quotation marks in a string
 
Well, I've just found the answer myself :)
Use Print instead of Write.
Thanks Fabian.
Fabian


"Fabian Grodek" wrote:

Hi,
I want to run a macro that writes out to a text file the following string:
<gamma unit="DEG" 0.0 </gamma

I've tried the following method:
Write #1, "<gamma unit=""DEG"" 0.0 </gamma"

But then I get exactly that:
"<gamma unit=""DEG"" 0.0 </gamma"

Of course, I don't want the double quotation marks, but only once (i.e.,
"DEG", not ""DEG"").

Any hint will be greatly appreciated.
Fabian


Henry Markov[_2_]

Quotation marks in a string
 
"<gamma unit=" & chr(34) & "DEG" & chr(34) & " 0.0 </gamma"

"Fabian Grodek" wrote in message
...
Hi,
I want to run a macro that writes out to a text file the following string:
<gamma unit="DEG" 0.0 </gamma

I've tried the following method:
Write #1, "<gamma unit=""DEG"" 0.0 </gamma"

But then I get exactly that:
"<gamma unit=""DEG"" 0.0 </gamma"

Of course, I don't want the double quotation marks, but only once (i.e.,
"DEG", not ""DEG"").

Any hint will be greatly appreciated.
Fabian




Fabian Grodek

Quotation marks in a string
 
Thanks Henry.
That's another option if I need to use the "Write" method anyway.
Fabian

"Henry Markov" wrote:

"<gamma unit=" & chr(34) & "DEG" & chr(34) & " 0.0 </gamma"

"Fabian Grodek" wrote in message
...
Hi,
I want to run a macro that writes out to a text file the following string:
<gamma unit="DEG" 0.0 </gamma

I've tried the following method:
Write #1, "<gamma unit=""DEG"" 0.0 </gamma"

But then I get exactly that:
"<gamma unit=""DEG"" 0.0 </gamma"

Of course, I don't want the double quotation marks, but only once (i.e.,
"DEG", not ""DEG"").

Any hint will be greatly appreciated.
Fabian






All times are GMT +1. The time now is 08:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com