# Strip html and create plain text

**URL:** <https://community.parabola.io/t/strip-html-and-create-plain-text/695>\
**Category:** Ask a question\
**Created:** [June 15, 2020, 2:17pm UTC](https://community.parabola.io/t/strip-html-and-create-plain-text/695 "2020-06-15T14:17:08Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Brian\_Brewer](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/brian_brewer/32/480_2.png) [@Brian\_Brewer](https://community.parabola.io/u/Brian_Brewer)\
**Post date:** [June 15, 2020, 2:17pm UTC](https://community.parabola.io/t/strip-html-and-create-plain-text/695/1 "2020-06-15T14:17:08Z")

</div>

New parabola user here. Is there an easy way to strip html from a column and turn it into plain text?

Many thanks in advance…

---

<div class="post-metadata">

**Author:** ![brian](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/brian/32/11_2.png) [@brian](https://community.parabola.io/u/brian)\
**Post date:** [June 15, 2020, 10:11pm UTC](https://community.parabola.io/t/strip-html-and-create-plain-text/695/2 "2020-06-15T22:11:13Z")

</div>

Hey Brian,

Your best bet is to use a Regular Expression in the RegEx step.

I looked at the community posted expressions on [https://regexr.com/](https://regexr.com/) and this one seems best:

`(<script(\s|\S)*?<\/script>)|(<style(\s|\S)*?<\/style>)|(<!--(\s|\S)*?-->)|(<\/?(\s|\S)*?>)`

Try that out in the expression box. Set it to replace with nothing.

If you have non-tag things you need to remove, like non-breaking spaces `&nbsp;` then you will need to take care of those separately.

---

<div class="post-metadata">

**Author:** ![zach](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/zach/32/401_2.png) [@zach](https://community.parabola.io/u/zach)\
**Post date:** [June 15, 2020, 10:28pm UTC](https://community.parabola.io/t/strip-html-and-create-plain-text/695/3 "2020-06-15T22:28:25Z")

</div>

If you want to extract the text content of a full webpage, using @brian’s regex is pretty safe.

If your columns just contain very simple html snippets, and you know there aren’t `<script>` and `<style>` tags, you might be able to use a simpler expression:

`<.*?>`

---

<div class="post-metadata">

**Author:** ![Brian\_Brewer](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/brian_brewer/32/480_2.png) [@Brian\_Brewer](https://community.parabola.io/u/Brian_Brewer)\
**Post date:** [June 16, 2020, 9:19pm UTC](https://community.parabola.io/t/strip-html-and-create-plain-text/695/4 "2020-06-16T21:19:44Z")

</div>

Brian & Zach - thanks so much! Both approaches seem to work.
