need help on formula 1

[vega83]

Friends I need some help on formula I am trying to create

I have a field which is like a message

Tickets are sold for less price , etc.
SO if my message has word sold I need to hilight it in red, just that one word. Any help please?

Vega

 

[lbass]

Try something like this and format the formula by going to format field->paragraph->text interpretation->HTML text:

left({table.message},instr({table.message},"sold")-1)+"<font color=red>"+"sold"+"</font color>"+mid({table.message},instr({table.message},"sold")+5)

-LB

 

[vega83]

You are a genius!!!

 

[vega83]

LB is there a way i can check for case senstive or like word

example Sold, sold, solden etc?

 

[vega83]

I got it, i used lower case fun and if condition thanks!

 

[lbass]

stringvar x := {table.message};
stringvar y := "sold";
if ucase(x) like "*"+y+"*" then
left(x,instr(ucase(x),ucase)-1)+
"<font color=red>"+y+"</font color>"+
mid(x,instr(ucase(x),ucase)+len(ucase))

This would just color the "sold" in "solden" though.

-LB