Brian Dunning's FileMaker Custom Functions

cf_RomanNumeral ( _number ; _digit ; _Kmarker )

Swaps out arabic numbers for roman numerals

  Average rating: 4.4 (37 votes) Log in to vote

Christopher Gauntt   Christopher Gauntt
Cordega Solutions
http://cordega.com

Share on Facebook Share on Twitter

  Sample input:
cf_RomanNumeral ( 953214 ; 1; "" )
or
cf_RomanNumeral ( 953214 ; 1 ; "p" )
  Sample output:
C̅M̅L̅MMMCCXIV
or
(CML)MMMCCXIV

(note: normally, the ̅ character will merge with the character preceding it, if the font supports it. Otherwise use the "p" option)

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

This recursive function swaps out arabic numbers with roman numerals.

You have the option of indicating multiples of 1000 over 3,999 with either parenthesis or an overline over the letter. e.g. (XIV)CCII = 14,202

For numbers that are 0 or less, it will return "N" which stands for null.

This function can calculate roman numerals for numbers up to 3,999,999.

Requires FileMaker Pro version 10 or later to use the "Char" sub-function

 

Comments

Phil   Phil, Switzerland
Jun 20, 2014
Very great function.
If you have other functions to buy, I'm interested.
Best Regards
 

Log in to post comments.

 

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

Under construction. Email me your wish list for improvements.