AddOrdinalSuperscript ( number )

Adds a superscripted ordinal text to the passed number

Be the first to rate this function Log in to vote

Paul - Show more from this author
Peak 14 LLC
http://www.peak14.solutions

Sample input:

AddOrdinalSuperscript ( 1 )

Sample output:

1st

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

/*
 *  CUSTOM FUNCTION
 *    AddOrdinalSuperscript ( number )
 *
 *  DESCRIPTION
 *    Adds a superscripted ordinal text to the passed number
 *
 *  PARAMS
 *    number: The number you'd like to add the text to
 *
 *  RETURNS
 *    The passed number with superscrtiped ordinal text
 *
 *  DEPENDENCIES
 *    --NONE--
 *
 *  CHANGELOG
 *    2020-03-19: Paul McCudden (paul@peak14.solutions): Created
*/

Let (
    [
        ~numRight = Right ( number ; 1 );
        ~2numRight = If ( Length ( number ) > 1 ; Left ( Right ( number ; 2 ) ; 1 ) );
        ~superscript = TextStyleAdd ( Case (
            ~numRight = 1 and ~2numRight <> 1 ; "st" ;
            ~numRight = 2 and ~2numRight <> 1 ; "nd" ;
            ~numRight = 3 and ~2numRight <> 1 ; "rd" ;
            "th"
        ) ; Superscript )
    ];

    number & ~superscript

)

Great for displaying numbers on layouts.

Comments

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

AddOrdinalSuperscript ( number )

Comments

Support this website.

Support this website.