Need a formula in my calc field that will look for more than twenty different words
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?