HiliteSingle ( text ; searchString ; color )

Returns text with every occurrence of searchString in text changed to the specified color.

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

Michael Horak
*COMMENT Visual Realisation
http://comment.cjb.net/

Sample input:

HiliteSingle ( "Catalog of cats" ; "caT" ; RGB (255;0;0) )

Sample output:

{Cat}alog of {cat}s

(the strings in curly braces are in red color)

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

/*
HiliteSingle function

Author
*COMMENT Visual Realisation

Format
HiliteSingle ( text ; searchString ; color )

Parameters
text - any text expression or text field;
searchString - any text expression or text field;
color - any integer number from 0 to 16777215.

Data type returned
text

Description
Returns text with every occurrence of searchString in text changed to the specified color. 
The HiliteSingle() function is NOT case-sensitive. Occurences of searchString are matched regardless of case, and returned in their original case.

October 3, 2006
*/

Let ( [
// TEST FOR MATCH
pos = Position ( text ; searchString ; 1 ; 1 ) 
] ;
// IF MATCH IS FOUND
Case ( pos ;
// BEGIN CALCULATION
Let ( [
textBefore = Left ( text ; pos - 1 ) ;
len = Length ( searchString ) ;
string = Middle ( text ; pos ; len ) ;
textAfter = Right ( text ; Length ( text ) - pos - len + 1 ) 
] ;
textBefore & TextColor ( string ; color ) & HiliteSingle ( textAfter ; searchString ; color ) 
) ;
// ELSE RETURN TEXT
text )
)

Returns text with every occurrence of searchString in text changed to the specified color.

The HiliteSingle() function is NOT case-sensitive. Occurences of searchString are matched regardless of case, and returned in their original case.

Comments

		Steve Hearn, CoreSolutions Software Inc, London ON Canada Apr 15, 2010
I've modified this function to use FM11's new highlight function. No need for color param. /* HiliteSingle function Author COMMENT Visual Realisation Format HiliteSingle ( text ; searchString ; color ) Parameters text - any text expression or text field; searchString - any text expression or text field; Data type returned text Description Returns text with every occurrence of searchString in text highlighted. The HiliteSingle() function is NOT case-sensitive. Occurences of searchString are matched regardless of case, and returned in their original case. Updated to use FileMaker 11's highlight functionality Steve Hearn shearn@coresolutions.ca April 15, 2010 / Let ( [ // TEST FOR MATCH pos = Position ( text ; searchString ; 1 ; 1 ) ] ; // IF MATCH IS FOUND Case ( pos ; // BEGIN CALCULATION Let ( [ textBefore = Left ( text ; pos - 1 ) ; len = Length ( searchString ) ; string = Middle ( text ; pos ; len ) ; textAfter = Right ( text ; Length ( text ) - pos - len + 1 ) ] ; textBefore & TextStyleAdd ( string ; HighlightYellow ) & HiliteSingle ( textAfter ; searchString ) ) ; // ELSE RETURN TEXT text ) )

		Brian Roy, San Francisco Jan 3, 2013
Hi, First, thank you for the function. I'm having trouble saving it, though. //TEST FOR MATCH pos = Position ( text ;....) I keep getting an error telling me that "text" is a specified parameter that cannot be found. Any help on this would be great--thanks.

		comment, VR Jan 3, 2013
You need to define the three parameters ( text ; searchString ; color ) within the 'Edit Custom Function' window. See the help for more: http://www.filemaker.com/12help/html/fmpa_custom.23.5.html#1027698

		Harry, Brooklyn Oct 14, 2013
After having the function ready, how do I use it. Is is through a script or what? Please give me an idea

		comment, VR Oct 16, 2013
Once you have defined the custom function, you use like any other function.

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