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.
Unfortunately, activation email could not send to your email. Please try again.

Remove quotes from results of TEXT functions

Thread ID:

Created:

Updated:

Platform:

Replies:

126987 Oct 19,2016 03:23 PM Oct 21,2016 04:27 AM WPF 3
loading
Tags: Calculate
Jacob
Asked On October 19, 2016 03:23 PM

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"

Kanimozhi Bharathi [Syncfusion]
Replied On October 20, 2016 08:12 AM

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 


Jacob
Replied On October 20, 2016 11:03 AM

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

-Jacob

Kanimozhi Bharathi [Syncfusion]
Replied On October 21, 2016 04:27 AM

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


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;