STRIP HTML TAGS FOR EXPORT

ALW

I have an HTML Notes field that I want to export to Excel but remove the HTML tags first. I want to find all instances of the html tags and remove them to store in my plain text attribute for export. Has someone written code to do this in the past? I have seen several posts regarding this but never actual code to strip the html.

Thanks!

rob_h7

Here you go...this should work.

Notes.MessageClean=REPLACE_PATTERN(Notes.MessageHTML, '<(.|\n)+?>', ' ')

hpl123

I actually THINK you can just have a rule copy the content to a plain text (non html) attribute:
If Bo.HtmlAttribute WAS CHANGED Then Bo.NonHtmlAttribute=Bo.HtmlAttribute

NB: If you have complex HTML and divs and stuff that would of course probably not be stripped using the above approach. If you use some HTML formatting etc. only, I think the above works though.

ALW

Thanks Rob - that did it!

Henrik - I did try what you were describing before I posted here and it didn't work.

rob_h7

8-)