PARSEFRACTION function

PARSEFRACTION(textualFraction) PARSEFRACTION(textualFraction)

textualFraction — Text or { Text }

The text string containing a fraction.

Returns — Number or { Number }

The number found in the given text string.

Interprets a text string as a number and returns it, where the text string is expected to contain a fraction (a denominator, a division symbol and a numerator), optionally preceded by an integer. PARSEFRACTION("3 3/4")PARSEFRACTION("3 3/4") returns 3.75.

PARSEFRACTION takes the language of the app into account when converting text strings to numbers. When PARSEFRACTION is used with an app whose language is set to German, for instance, text strings representing numbers should use a comma (",") as a decimal separator. When PARSEFRACTION is used with an app whose language is set to UK English, a decimal point (".") should be used. Language-appropriate thousands separators may be used.

This function is very flexible in terms of what input it can parse. For instance, PARSEFRACTION("003,500 4/8 lbs")PARSEFRACTION("003,500 4/8 lbs") returns 3500.5.

This function is specific to Calcapp.

Related functions

Examples

PARSEFRACTION("3 3/4")PARSEFRACTION("3 3/4")

Returns 3.75.

PARSEFRACTION({ "3 3/4", "3/16" })PARSEFRACTION({ "3 3/4"; "3/16" })

Returns the array { 3.75, 0.1875 }{ 3,75; 0,1875 }.

PARSEFRACTION("003,500 4/8 lbs")PARSEFRACTION("003,500 4/8 lbs")

Returns 3500.5.