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

Thread ID:	Created:	Updated:	Platform:	Replies:
143061	Mar 2,2019 06:25 PM UTC	Mar 4,2019 12:18 PM UTC	WinForms	1

Subscribe to this post

Tags: Calculate

Gregory Pe

Asked On March 2, 2019 06:25 PM UTC

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

Reply | Reply with quote

Arulraj A [Syncfusion]

Replied On March 4, 2019 12:18 PM UTC

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.

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

Reply | Reply with quote

CONTACT US

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

Thread ID:

Created:

Updated:

Platform:

Replies:

Please sign in to access our forum

CONTACT US