 |
| Screenshot of cell containing HTML tags and text |
The regex uses 'replace' to identify the HTML tags and remove then (or technically replace them with nothing):
var cleanContent = cell.replace(/<[^>]+>/mg,"");
Regex - remove HTML tags.xlsx
I'm Phil Bainbridge and I aim to share my experiences of IT projects I've worked on as I continue to learn and develop, through this blog. My main coding language is Google Apps Script (with JavaScript), but there is also some: PowerShell, HTML, SQL and jQuery.
Pages
▼
Sunday 15 September 2019
Remove HTML tags in a cell by a regex
The following Google Apps Script is designed to remove all HTML tags within the content of a cell by using a regular expression (regex). It was developed as a more advanced version of this HTML email body blog post in that it could dynamically remove various instances of HTML tags used (eg <font></font>, <br />, <strong></strong>) all in one go.
The regex uses 'replace' to identify the HTML tags and remove then (or technically replace them with nothing):
Regex - remove HTML tags.xlsx
The regex uses 'replace' to identify the HTML tags and remove then (or technically replace them with nothing):
Regex - remove HTML tags.xlsx
No comments:
Post a Comment