Brian Dunning's FileMaker Custom Functions

cf_convertHexRGB ( HexNumber ; Separator )

Convert hexadecimal RGB values

  Average rating: 3.8 (38 votes) Log in to vote

Klemens Müller   Klemens Müller
Klemens Müller

Share on Facebook Share on Twitter

  Sample input:
cf_convertHexRGB ( "00AACF" ; " " )
  Sample output:
0 170 207

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

cf_convertHexRGB( HexNumber; Separator )
by Klemens Müller,, 05.07.2006
This is a simple example to convert hexadecimal RGB values. The function returns the decimal value for each byte of a three bytes long hexadecimal value. Please, let all of us know, if you discover an error or you create a shorter version of this function.

1. Remove unnecessary characters in the input.
2. Range of possible characters in the hexadecimal number system. The decimal value of each character will be represented by the term "position - 1".
3. Each returned value will be separated with in this parameter submitted string.



Log in to post comments.


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

Under construction. Email me your wish list for improvements.