How do I get the value from the HTML content stored as string in the database column?

In this article, we will learn how to get the value from the HTML content stored as a string in the database column.

1. Identify the column where the data contains HTML tags.
2. HTML tags from the text column can be removed by using the below expression. Create an expression column in your data source using the below expression.

Expression to remove HTML tags from the data, when PostgreSQL Data Store is configured.

regexp_replace (substring(REPLACE(REPLACE([Data], ',', ''), '<br>', ',') from '<row>.*</row>'), E'<[^>]+>', '', 'gi')

3. Bind this expression column with a grid/table widget to see the isolated value in each row.

Actual Data:

After Expression:

Related Articles

• How to configure expressions