CalcQuickBase - Getting Rid of Everything Except Numbers - use - Text Functions

[Gregory Pe]

Hi

Getting Rid of Everything Except Numbers

Linda has a column that contains alpha and numeric characters. She needs to retain the numeric characters and delete the alpha ones. For example, a cell may contain y,y.d?d10003pyu111 and she wants to end up with 10003111.

in excel is

=EXTRACTNUMBERS("yydd10003pyu111", TRUE)

is it possible to use - Text Functions

https://help.syncfusion.com/windowsforms/calculate/supported-formulas

CalcQuickBase cq

Regards,

Gregory

[Arulraj A]

Hi Gregory, 

Thanks for using Syncfusion product. 

To get the numeric value from the string, you could implement the custom function and include that function CalcEngine using AddFunction method. Please refer the following code example and the sample. 

C# 

private static CalcData calcData = new CalcData(); 

private static CalcEngine engine = new CalcEngine(calcData); 

engine.AddFunction("EXTRACTNUMBERS", new CalcEngine.LibraryFunction(ComputeEXTRACTNUMBERS)); 

 

var result = engine.ParseAndComputeFormula("EXTRACTNUMBERS(\"yydd10003pyu111\")"); 

Console.WriteLine("Result: " + result); 

 

public static string ComputeEXTRACTNUMBERS(String args) 

{ 

    string number = new String(args.Where(Char.IsDigit).ToArray()); 

    return number; 

} 

 

Sample link: http://www.syncfusion.com/downloads/support/directtrac/general/ze/Calculate_BasicDemo1976206257  

 

UG link: https://help.syncfusion.com/windowsforms/calculate/custom-function#add-custom-function  

Please get back us if you need any further assistance on this. 

Regards, 

Arulraj A