You can translate the question and the replies:

Removing html from a string

What is the simplest way of removing html from a string? I have attempted to create a map of various tags and parts of the html, but this is a very flawed way of doing this, leaving numbers, characters and tags which haven't been accounted for in the data.
string conversion HTML
user
31-12-2021 05:30:01 -0500
code

1 Answer

Hi, For your scenario to remove html tags in a string, you can use the [REPLACE](https://community.denodo.com/docs/html/browse/latest/en/vdp/vql/functions/text_functions/text_functions#replace) or [REGEXP](https://community.denodo.com/docs/html/browse/latest/en/vdp/vql/functions/text_functions/text_functions#regexp) functions in Denodo. For instance, use the REGEXP function like below to remove the html tags from the output string: `regexp(column0 ,'<[^>]*>', '')` For information about other available text processing functions in Denodo, refer to the [Text Functions](https://community.denodo.com/docs/html/browse/latest/en/vdp/vql/functions/text_functions/text_functions#text-functions) section of the Virtual DataPort VQL Guide. Hope this helps!
Denodo Team
03-01-2022 02:21:45 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here