HexToRGBspecial ( Hex ; Output )

Converts Hex into RGB value showing, R, G, or B depending on

Average rating: 4.1 (30 votes) Log in to vote

Doug Jacobs - Show more from this author
Restylers Choice

Sample input:

HexToRGBspecial ( #08530E ; "red" )
HexToRGBspecial ( #08530E ; "green" )HexToRGBspecial ( #08530E ; "blue" )

Sample output:

8
83
14

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

/*
HexToRGBspecial by
Doug Jacobs

based on cf_convertHexRGB by Klemens Müller, www.klemenso.de
*/
Let( [
  hex   = Substitute( HexNumber ; [" " ; ""];["#";""] ) ;  /*1*/
  range = "0123456789ABCDEF" ;                             /*2*/
  r1    = Middle( hex ; 1 ; 1 ) ;
  r2    = Middle( hex ; 2 ; 1 ) ;
  g1    = Middle( hex ; 3 ; 1 ) ;
  g2    = Middle( hex ; 4 ; 1 ) ;
  b1    = Middle( hex ; 5 ; 1 ) ;
  b2    = Middle( hex ; 6 ; 1 ) ;
  r1    = Position( range ; r1 ; 1 ; 1 ) - 1  ;
  r2    = Position( range ; r2 ; 1 ; 1 ) - 1  ;
  g1    = Position( range ; g1 ; 1 ; 1 ) - 1  ;
  g2    = Position( range ; g2 ; 1 ; 1 ) - 1  ;
  b1    = Position( range ; b1 ; 1 ; 1 ) - 1  ;
  b2    = Position( range ; b2 ; 1 ; 1 ) - 1  ;
  red   = r1 * 16 + r2 ;
  green = g1 * 16 + g2 ;
  blue  = b1 * 16 + b2 ;

out= Case(Output="red";red;Output="blue";blue;Output="green";green)
] ; 
out )

Converts a hexideciaml value to individual red, green and blue values based upon your selection for output. Ths allows you to separate each color into an individual field. Simply put "red", "Green", or "Blue" as the ouput and only that color's value will appear in the output of the function. This is great for sending values to FileMaker's text formatting functions for changing text color!

Comments

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

HexToRGBspecial ( Hex ; Output )

Comments

Support this website.

Support this website.