We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

Remove quotes from results of TEXT functions

Hello,
Is there some mechanism built into the CalcQuickBase class that disables the quotes surrounding the result?
The result of text functions return the result as "Example" is there a way to force the result as Example without the quotes?

Example:
this.Calculator["A"]
"test"

this.Calculator.ParseAndCompute("Concatenate([A], [A], [A], [A], [A], [A])");
"\"testtesttesttesttesttest\""

I would instead like the result to be: "testtesttesttesttesttest"

3 Replies

KB Kanimozhi Bharathi Syncfusion Team October 20, 2016 12:12 PM UTC

Hi Jacob Babbel, 
 
We have checked your issue and you can overcome this issue by setting “UseNoAmpersandQuotes” property of CalcEngine to true like below code example 
 
 
CalcQuickBase calculator = new CalcQuickBase(); 
calculator["A"] = "test"; 
calculator.Engine.UseNoAmpersandQuotes = true; 
var result = calculator.ParseAndCompute("Concatenate([A], [A], [A], [A], [A], [A])"); 
 
 
Please let us know if you need any further clarifications. 
 
Regards 
Kanimozhi B 



JA Jacob October 20, 2016 03:03 PM UTC

This is exactly what I was looking for, thank you.

-Jacob


KB Kanimozhi Bharathi Syncfusion Team October 21, 2016 08:27 AM UTC

Hi Jacob, 
 
Thank you for your update. 
 
Regards 
Kanimozhi B 


Loader.
Live Chat Icon For mobile
Up arrow icon