Support Board
Date/Time: Fri, 29 Nov 2024 18:50:45 +0000
Escape double quotation mark (
View Count: 339
| [2023-01-15 02:47:35] |
| User656492 - Posts: 143 |
|
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: 17233 |
|
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: 2184 |
|
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: 143 |
|
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: 2184 |
|
"" 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: 143 |
|
Perfect. Thanks!!!
|
To post a message in this thread, you need to log in with your Sierra Chart account: