We're using the "Solutions" standard object as our knowledge base, with "Solution details" standard field is a Rich Text Area field (32000 characters).
The field structure looks like this:
Purpose (header 1)
Appropriate versions (Header 2)
text: version numbers.
Additional Details (Header 3)
What I want to do is update the text under "header 2" without the need to enter to each solution and field and type the versions manually. I created a custom picklist field called "versions", and tried copying the picklist value into the "Solution details" field via workflow rule and field update - the problem is that it causes losing all HTML and turns this field to text only. I understood it's possible to update this without loosing HTML only with trigger. Did anyone accomplished something similar? are there even "Substitute" / "replace" functions in triggers??