Hightlight Spaces 1

[JCDugas]

Anyone know how to hightlight the number of spaces in a string field?

What I want to do is hightlight three spaces with a certain color and hight two spaces with another.

Thanks,

Jeremy

 

[satinsilhouette]

I do not believe you can highlight a space(s) in Crystal.

 

[JCDugas]

Maybe I should have included this code. Spaces can be highlighted, I'm just not sure if I run through the field once then run through it again with another replace formula.



replace({FIELD}," ",
"<font color=red>"+"<b>"+"@@"+"</b>"+"</font color>")

Change the field Text Interpretation to HTML.

Jeremy

 

[satinsilhouette]

Looks like you need to search for the spaces to do the replace, did you try using the instr function to look for "^^^" in the text you are trying to highlight (^ indicates a space)?

 

[lbass]

You are not coloring a space here, but characters that you are plugging into a space, but I guess you know that.

Try the following where the longer space replace formula is nested within the shorter one:

replace(replace({FIELD}," ",
"<font color=red>"+"<b>"+"@@@"+"</b>"+"</font color>")," ", "<font color=blue>"+"<b>"+"@@"+"</b>"+"</font color>")

-LB

 

[JCDugas]

Thanks lbass, that worked!!!!