Remove quotes from results of TEXT functions

[Jacob]

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]

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]

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

-Jacob

[Kanimozhi Bharathi]

Hi Jacob, 

 

Thank you for your update. 

 

Regards 

Kanimozhi B