FractionNumerator

Extracts numerator from a string representing a fraction.

Average rating: 4.5 (31 votes) Log in to vote

Brett Buchmiller
None
www.filemaker.com

Sample input:

FractionNumerator( "3/8" )

FractionsNumerator( "5/16" )

FractionNumerator( "3 7/8" )

Sample output:

3

5

31

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

/*
Extract numerator as number from text string representing a fraction
© Brett Buchmiller 10-2011
*/

Let(
[	LocationSpace = Position( Input ; " " ; 1 ; 1 ) ;
	LocationSlash = Position( Input ; "/" ; 1 ; 1 ) ;
	LengthText = Length( Input ) ;
	WholeNumber = If( LocationSpace > 0 ;
		GetAsNumber( Left( Input ; LocationSpace - 1 ) ) ;
		"" )
];

If(
	IsEmpty( WholeNumber ) ;
	GetAsNumber( Left( Input ; LocationSlash - 1 ) ) ;
	WholeNumber * FractionDenominator ( Input ) + GetAsNumber ( Middle( Input ; LocationSpace+1 ; LocationSlash - LocationSpace ) )
)
)

Extracts the numerator from a string representing a fraction. Will work with improper fractions as well as mixed numbers. Result is numeric.

Comments

		John Sauer, Boston, MA Mar 7, 2018
This function fails on negative inputs. FractionNumerator("-5 1/2") returns -9, but the correct value to return is -11. The last line, "GetAsNumber(Middle..." should be added to the value preceding it if WholeNumber is positive, but subtracted from it if WholeNumber is negative.

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

FractionNumerator

Comments

Support this website.

Support this website.