Dynamically hiding HTML tags
I have a 'Body' (rich text field) that captures the body of an email from Outlook through a Quick Base Pipeline. The rich text from 'Body' is then passed to another field, 'Body Field' (rich text ...
Forum Discussion
It's not the cleanest... but since your Body Field is already a QB Formula field, you might be able to get away with doing some SearchAndReplace() functions to change the <body> and </body> to say <div> </div>... and then remove the html tags all together.
Or, a more non native would be too see how to just get the body.innerHTML of the original html information... but that's a JavaScript notation, not QB Formula notation.
Or also instead of mid, try part instead, using <body as the delimiter.
Part([Body],2,"<body")
You'll still need to purge out the other information of the rest of the opening body tag... but this could get you in the right direction.
------------------------------
Ryan Stanford
------------------------------
Or, a more non native would be too see how to just get the body.innerHTML of the original html information... but that's a JavaScript notation, not QB Formula notation.
Or also instead of mid, try part instead, using <body as the delimiter.
Part([Body],2,"<body")
You'll still need to purge out the other information of the rest of the opening body tag... but this could get you in the right direction.
------------------------------
Ryan Stanford
------------------------------