Conditional formatting specific words
Is there a way to have speciifc words withing a field show up conditionally formatted? For example I'd like to bold the third word in every record or something like that.
You will have to write a script to do it and do the parsing yourself, and replace the text. Look up Conditions Formating in Help.
…or use TextStyleAdd( text ; styles ) instead of Conditional Formatting.
Set Variable ( $x ; your_table::your_text_field )
Set Field[ your_table::your_text_field ; LeftWords( $x ; 2 ) & " " & TextStyleAdd( MiddleWords( $x ; 3 ; 1 ) ; Bold + HighlightYellow ) & " " & RightWords( $x ; WordCount( $x ) - 3 ) )
I'm terrible at this scripting stuff but I do understand most of what you wrote. Unfortunatley what I had originally wrote was a bit inaccurate - I need to search for specific words within the field to change the formatting of. Can I do a search on the parse?
Figured it out using the substitute function:
Substitute ( Description ; "SLOW" ; TextStyleAdd ( "SLOW" ; Bold ) )
Now I need to do something with wildcards where after a / I need similar formatting. I hear you can't do wildcards within functions?
You cannot use wild cards in text functions, they are only used in find criteria.
Also, substitute is case sensitive. if the text reads "slow" instead of "SLOW" your expression won't change the style to bold.
Retrieving data ...