Inserting Commas In Numbers Within FileMaker Text Calculations

From Dwayne Wright PMP, PMI-ACP, CSM
Certified FileMaker Developer

WEB: www.dwaynewright.com
EMAIL: info@dwaynewright.com
TWITTER: dwaynewright
YOUTUBE: FileMakerThoughts

Added the custom function of insert_commas to my InBizness product and thought I’d mention it here (just in case someone else is looking for something like this).


This nifty function inserts commas before every third digit before a decimal point. Uses recursion to handle any number, including negative values and decimals. This allows me to have a calculated number in a text calculation field and still show the commas. So a calculated value of 2,000 will look that way instead of 2000.

The name of the function is insert_commas and I got it from the briandunning.com web site. The credits for uploading this function to that site are noted as Matthew Stetson, Antidote Solutions

The direct link to this custom function is ...

http://www.briandunning.com/cf/483
=
More info about the author and FileMaker in general, contact me at info@dwaynewright.com.

© 2008 - Dwayne Wright - dwaynewright.com

The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.