Newest functions Upload a function Leave a tip My account

There are 2,520 functions in this library.

GetAsArabic ( romanNumber )

GetAsArabic( romanNumber ) returns the arabic number equivalent for a roman number.

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

Jeremy Bante OshVay Systems, Inc. http://www.oshvay.com

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

/*GetAsArabic( romanNumber ) returns the arabic number equivalent to romanNumber [text]. It will return correct values for both correctly and incorrectly formed roman numberals, and ignore all characters other than “i”, “v”, “x”, “l”, “c”, “d”, and “m”.*/ Let( roman = Lower( romanNumber); //normalize romanNumber to lowercase //tally values for letters (PatternCount( roman, "i") * 1) + (PatternCount( roman, "v") * 5) + (PatternCount( roman, "x") * 10) + (PatternCount( roman, "l") * 50) + (PatternCount( roman, "c") * 100) + (PatternCount( roman, "d") * 500) + (PatternCount( roman, "m") * 1000) - //subtract for complex values (PatternCount( roman, "iv") * 2) - //(i+v)-iv=(1+5)-4=2 (PatternCount( roman, "ix") * 2) - //(i+x)-ix=(1+10)-9=2 (PatternCount( roman, "xl") * 20) - //(x+l)-xl=(10+50)-40=20 (PatternCount( roman, "xc") * 20) - //(x+c)-xc=(10+100)-90=20 (PatternCount( roman, "cd") * 200) - //(c+d)-cd=(100+500)-(400)=200 (PatternCount( roman, "cm") * 200) //(c+m)-cm=(100+1000)-900=200 ) //end Let() Click to copy

This list has two functions already for arabic-to-roman number conversion (RomanNumberal_1to4K(Parameter_number) by Brad Lowry, and RomanNumerals ( PageNumber ) by Don Wieland); this function performs the inverse operation. GetAsArabic( romanNumber ) returns the arabic number equivalent to romanNumber [a text string representing a roman numeral]. It will return correct values for both correctly and incorrectly formed roman numberals, and ignore all characters other than �i�, �v�, �x�, �l�, �c�, �d�, and �m�.

 

Comments

		Shah, Maaden, Saudi Arabia Aug 5, 2020
This is Shah, good job done, can you help me out here, I am looking for custom function for text field converted to arabic text in another field. I found only numeric converted to arabic text.

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.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 20 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: