How can extract just the text from a rich text field?

Question

I have a rich text field that looks like below (a snip from it)If([Rejected/Cancelled]=true, "

Rejected/Cancelled

",[Approval Not Required]=true,"

No Approval Required

",[Most Recent Admin Final Approval]="Approved","

Sent to AP for Processing

".....etc)I need the actual text (ie 'Reject/Cancelled, No Approval Required, etc) extracted for form rules and other reasons.However, if I mirror the field as a test to see what QB sees, an example of the result is:

Manager Sign & Approve

Essentially, it shows literally what is in the Rich Text field. Is my only option to duplicate the field exactly, but remove the formatting? I was hoping I can reference the field in some way, so that if I change my if/then rules in the future, I don't have to change them in two spots. Any sneaky way to reference a Rich Text field and have it return only the text?------------------------------Mike Tamoush------------------------------

GauravSharma1 · Answer

Hi Mike,Hope you are doing well.You can use the below formula for the same. Just replace my [Your Rich Text Field] field with your actual rich text field.Left(Part([Your Rich Text Field],2,">"),"<")The above formula will extract only text. Try this out and let me know if this works for you in this case.Thanks,------------------------------Gaurav SharmaBusiness Application ArchitectWesthaven Power, Inc+91-8826743679------------------------------

Sign up

Login to the community