Home / Q&A / Parse field with HTML to generate rows based on specific character string.
You can translate the question and the replies:

Parse field with HTML to generate rows based on specific character string.

I have a view with a field called description. This has custom HTML and I am trying to create a Select statement that will parse a new row in the output everytime "/>" appears in the HTML.
html parse text to row
user
01-05-2020 12:50:45 -0400

3 Answers

I figured this out on my own.... Creating an Array for rows with Split and Flatten functions (specifically for US data that is stored via an HTML view) Splitting the description function into an array. Then using the flatten feature in Denodo. The function results in multiple rows for each array (with a new field called ‘string.’ The ID number remains from the original table.
user
04-05-2020 00:44:07 -0400
This is the split function for my example split('/>', dv_myysql_table.field1)
user
04-05-2020 00:45:01 -0400
Hi, I am glad that you were able to figure it out. If I want to manipulate or transform values of fields with **text** datatype, I would use the necessary [Text Processing Functions](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/appendix/syntax_of_condition_functions/text_processing_functions) provided by Denodo Platform such as [SPLIT](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/appendix/syntax_of_condition_functions/text_processing_functions#split), [SUBSTRING](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/appendix/syntax_of_condition_functions/text_processing_functions#substring-substr) etc. Hope this helps!
Denodo Team
04-05-2020 07:59:15 -0400
You must sign in to add an answer. If you do not have an account, you can register here