REMOVE_HTML_TAGS

Syntax

REMOVE_HTML_TAGS(<string [containing HTML elements]>)

Description

Removes all HTML tags.

Example

Download the example file: HTML_File_Example.html

Given the following excerpt from the HTML file:

<tbody>
	<tr>
		<td>New York</td>
		<td>San Francisco</td>
		<td>Atlanta</td>
	</tr>	
	<tr>
		<td>Bread</td>
		<td>Biscuits</td>
		<td>Rolls</td>
	</tr>
	<tr>
		<td>Sandwich</td>
		<td>Soup</td>
		<td>Salad</td>
	</tr>
</tbody>

This examples removes all of the HTML tags and display the content of the HTML object in a string.

Select the column with your HTML data as the HTML argument.

The results is the content as a string type with the HTML tags removed.

New York San Francisco Atlanta Bread Biscuits Rolls Sandwich Soup Salad