uNmbr_00ConvertToNativeNumberAndEvaluate__CF ( stringToTreat )

Converts the received string to a native number (file) and executes the mathematical operation

Average rating: 3.0 (4 votes) Log in to vote

Sylvain Parent
Jefo Logistique
www.jefo.com

Sample input:

uNmbr_00ConvertToNativeNumberAndEvaluate__CF ( "( (2+12)*3)/10,6" )

Sample output:

3.9622641509433962

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

/*

uNmbr_00ConvertToNativeNumberAndEvaluate__CF ( stringToTreat )

Converts the received string to a native number (file) and executes the mathematical operation
If there is a calculation error returns nothing

Editing by Sylvain Parent on 2017.02.22 at 14:59
*/


Let ([

// Keep only significant characters in a calculation
stringToTreat= Filter ( stringToTreat ; "0123456789+-*/,.()%" ) ;

// Find the native decimal separator 
sepNative = Middle ( GetAsText ( 10/3 ) ; 2 ; 1 ) ;
otherSep = If ( sepNative = "," ; "." ; "," )  ;

// Replace separator
stringToTreat= Substitute ( stringToTreat ; otherSep ; sepNative ) ; 
// Replace the %
stringToTreat = Substitute ( stringToTreat ; "%" ; "/100" ) ; 

// Check that the result is good
evaluationIsOK = EvaluationError ( Evaluate ( stringToTreat ) ) = 0

]; 

If ( evaluationIsOK ; GetAsNumber ( Evaluate ( stringToTreat ) ) ; "" )

)

Converts the received string to a native number (file) and executes the mathematical operation.

The functions adapt to the native format of the FileMaker file. A point in the US a comma in Europe or Quebec.
The commas will be converted to a point if necessary. Points will be converted to comma if necessary.

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

uNmbr_00ConvertToNativeNumberAndEvaluate__CF ( stringToTreat )

Comments

Support this website.

Support this website.