Hello Everyone:
11gr2
APEX 18.1
I have a requirement where the contents of a very small table (<= 10 rows) is sent via APEX mail on a weekly basis.
One of the columns of the row contains free text which looks like this:
1. This is the first item. 2. This is the second item. 3. This is the third item.
The requirement owner has requested for the resultant email to convert this text within the HTML table so that it appears as an ordered list (example below):
1. This is the first item.
2. This is the second item.
3. This is the third item.
Truly, their only requirement is to have a "break" between each numbered item.
Is there any easy way to write this in HTML within my PL/SQL procedure.
This is what my table markup looks like so far:
l_body_html := l_body_html
||'<table id="Custom">'
||'<tr>'
||'<th>Header 1 </th>'
||'<th>Header 2 </th>'
||'<th>Header 3 </th>'
||'<th>Header 4 </th></tr>';
-- Insert data into table with relevant information
l_body_html := l_body_html
|| '<tr>'
|| '<td>'|| c1.field_1 ||'</td>'
|| '<td>'|| c1.field_2 ||'</td>'
-- This is the field that contains numbered sentences which would be converted to an ordered list
|| '<td>'|| c1.field_3 ||'</td>'
|| '<td>'|| c1.field_4 ||'</td></tr>';
l_body_html := l_body_html ||'</table>';
Thanks,
Aqua