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. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Remove quotes from results of TEXT functions

Thread ID:





126987 Oct 19,2016 07:23 PM UTC Oct 21,2016 08:27 AM UTC WPF 3
Tags: Calculate
Asked On October 19, 2016 07:23 PM UTC

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?


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

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

Kanimozhi Bharathi [Syncfusion]
Replied On 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. 
Kanimozhi B 

Replied On October 20, 2016 03:03 PM UTC

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


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

Hi Jacob, 
Thank you for your update. 
Kanimozhi B 


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.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon 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.Close Icon