Login Page - Create Account

Support Board


Date/Time: Fri, 29 Mar 2024 12:46:32 +0000



Escape double quotation mark (

View Count: 252

[2023-01-15 02:47:35]
User656492 - Posts: 106
Hi. Is it possible to do this?

=concatenate(" \" " , "apple" , " \" ") to produce this string: "apple"

where \ is the escape character? clearly \ is incorrect.

I've also tried char(34), but I get a NAME? error.
[2023-01-15 03:10:36]
Sierra_Chart Engineering - Posts: 13625
We will check on this.
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
Date Time Of Last Edit: 2023-01-15 03:10:42
[2023-01-16 23:01:36]
Jeffrey - Posts: 2090
Support for double double-quotes will be included in the next version. This will allow the formula ="""apple""" result in the text "apple", because a pair of double-quotes ("") will be interpreted as a single double-quote (") like most other standard spreadsheet software.
[2023-01-16 23:47:59]
User656492 - Posts: 106
This is great. So just to confirm, I'll be able to do something like:

= CONCATENATE("","apple","") and the resulting value will be "apple" ?
[2023-01-16 23:53:24]
Jeffrey - Posts: 2090
"" will result in an empty string.
""" is an incomplete string because there is no closing quote.
"""" will result in a single double-quote (").

So = CONCATENATE("","apple","") will result in: apple.

= CONCATENATE("""","apple","""") will result in: "apple".
Date Time Of Last Edit: 2023-01-16 23:56:18
[2023-01-17 00:05:55]
User656492 - Posts: 106
Perfect. Thanks!!!

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account