This is stumping me. The following is the formula I'm using to highlight key words I'm searching a text field for in my database. I need it to highlight/color the word each time it is found in a sentence.
The table and field is {ChatMessages.MESSAGE}
The prompt is {?Text_To_Search_for}
I have set text interpretation in format field to HTML
local stringvar notes:=lcase({ChatMessages.MESSAGE});
local numbervar i;
for i:=1 to count({?Text_To_Search_for}) do (
notes:=replace(notes,{?Text_To_Search_for},"<font color=#ff0000>" & {?Text_To_Search_for} & "</font>",1,-1,1);
);
notes
Can someone please assist me with this? Any direction/clarification is greatly appreciated. Thank you.
Mike
The table and field is {ChatMessages.MESSAGE}
The prompt is {?Text_To_Search_for}
I have set text interpretation in format field to HTML
local stringvar notes:=lcase({ChatMessages.MESSAGE});
local numbervar i;
for i:=1 to count({?Text_To_Search_for}) do (
notes:=replace(notes,{?Text_To_Search_for},"<font color=#ff0000>" & {?Text_To_Search_for} & "</font>",1,-1,1);
);
notes
Can someone please assist me with this? Any direction/clarification is greatly appreciated. Thank you.
Mike