color_convert_hex ( color_hex ; output_format )

convert hexadecimal color format to decimal format (used by FileMaker) or red green blue formats

Average rating: 3.7 (3 votes) Log in to vote

Thomas Siebert - Show more from this author
http://www.t-seabird.de

Sample input:

color_convert_hex ( "ffc858" ; "decimal" )

color_convert_hex ( "ffc858" ; "g" )

color_convert_hex ( "ffc858" ; "rgb" )

Sample output:

16762968

200

255¶200¶88

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

/*
color_convert_hex ( color_hex ; output_format )

version 2
---------------------------------------------
Thomas Siebert, 28.04.2017
info@t-seabird.de
www.t-seabird.de
---------------------------------------------

convert hexadecimal color format to decimal format (used by FileMaker) or red green blue formats

output_format = "r", "g", "b", "rgb" or "decimal"

*/

Let ([
hex = Substitute ( Filter ( Upper ( color_hex ) ; "0123456789ABCDEF" ) ; [ "A" ; ":" ] ; [ "B" ; ";" ] ; [ "C" ; "<" ] ; [ "D" ; "=" ] ; [ "E" ; ">" ] ; [ "F" ; "?" ] )  ; 
red = ( Code ( Middle ( hex ; 2 ; 1 ) ) - 48 ) + ( Code ( Middle ( hex ; 1 ; 1 ) ) - 48 ) * 16 ;
green = ( Code ( Middle ( hex ; 4 ; 1 ) ) - 48 ) + ( Code ( Middle ( hex ; 3 ; 1 ) ) - 48 ) * 16 ;
blue = ( Code ( Middle ( hex ; 6 ; 1 ) ) - 48 ) + ( Code ( Middle ( hex ; 5 ; 1 ) ) - 48 ) * 16 ;

decimal_format = RGB ( red ; green ; blue )

];

Case ( output_format = "r" ; red ; output_format = "g" ; green ; output_format = "b" ; blue ; output_format = "rgb" ; red & ¶ & green & ¶ & blue ; output_format = "decimal" ; decimal_format ; "" ) 

)

convert hexadecimal color format to decimal format (used by FileMaker) or delimited red green blue format

output_format = "r", "g", "b", "rgb" or "decimal"

Comments

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

color_convert_hex ( color_hex ; output_format )

Comments

Support this website.

Support this website.