Edit a Rich Text Long Text Field

Hello!

I am trying to create an automation that will look for a string in a rich text long text field, and delete that string from the field, while keeping the rest of the rich text in place. The string will ways be at the end of the field and will start with “[[[”.

I created a formula to identify the “[[[” and the text after it. Now I’m not sure what the best way to delete the results from that formula from the original field with an automation. Any ideas?

How about creating such a formula field and overriding it with automation?

LEFT(Notes,SEARCH("[[[",Notes)-1)

Part of the problem with dealing with rich text fields is that when you use a rich text field in a formula, you loose the rich text formatting.

If you want to retain rich text formatting when you manipulate the text, your best bet is to use scripting.

Ah, I see, so the formatting is lost.

Yes - the retaining the rich text formatting is exactly the issue! I will look into scripting. Thank you @kuovonne and @Sho!