I have some 80,000 records with a rich text body that has all of information in the field having the hide paragraph from web browser attribute set. Removing the check doesn’t remove the hidden attribute from the existing information stored in the field so that it can be seen in a browser. Does anyone know of a way to allow me to refresh the information contained in the field so that I can make the field visable in a browser.
Subject: It would be easy with the Midas Rich Text LSX
Sorry to immediately bring up a third party product, but there isn’t a sure fire way of doing it without. If all your rich text fields were one paragraph long, you could add a space before the field name and uncheck the box and fix it, but any with two or more paragraphs might not work. With the Midas Rich Text LSX, the code would be something like
Set doc = view.GetFirstDocument
While not (doc is nothing)
Call rtitem.ConnectBackend(doc.Handle, “Body”, True)
rtitem.Everything.ParagraphStyle = “-HIDE_WEB”
rtitem.Save
Set doc = view.GetNextDocument(doc)
Wend
which is pretty simple, and it should be able to handle 80,000 records in a couple of hours, easily. Midas is a commercial product, but $1000 for that task alone would probably justify it, and you could use it for a lot of other things as well. See http://www.GeniiSoft.com for details on Midas. You can even get an evaluation license and provie it will work and then pay for it (but you do have to pay if you use the eval license for production work such as this). Hope that helps.