AnsweredAssumed Answered

Need a formula in my calc field that will look for more than twenty different words

Question asked by RigneyJim on May 1, 2009
Latest reply on May 1, 2009 by comment_1

Title

Need a formula in my calc field that will look for more than twenty different words

Post

Hello,

 

 I was able to write this:   Substitute ( Text; "SUN" ;(TextStyleAdd ("SUN" ;Bold )))

 

This will look in my Text field and search for the word "SUN" and turn the word "SUN" bold. 

 

I have a data base with over 200 files (Speaches) containing a text field (Text) which contains a speach by someone.

I want a formula that will look at the Text field in each Speach file, search for certain words, and change each word bold.

 

I have a list of 40 or 50 key words I am searching for in the Text of the Speach files, and want each of the words, if it is found, to turn bold in the text field.  

 

Some of the words I want to turn bold are: "Vertical", "horizontal," "center," "spiral, "cosmic spring", etc.

 

How can I do it?

 

Thank you.

Outcomes