Please read the link from the FAQ (Frequently Asked Questions) on --> Re: 2. How do I ask a question on the forums? and answer questions #5 - #9

Also provide actual DDL (table definitions) and DML (insert statements) of your data.

58d5e9e1-b454-4507-a2d3-36f815435774 wrote:

 

hi ,

 

Have text data in clob data type field:

 

<p><u>Key Deliverables Update:</u></p><ul><li>Global Expansion - Transact with Credit Card PPOR GA date = Jul-2. Team will continue to identify any efficiencies possible.</li><li>CSP+BO teams have have provided PPOR and SWAG delivery dates for key items like MFA, GDPR, PO, Sales Led process, AD/Groups and other stories according to backlog priority. Services readout was completed Apr-16 with followups due this week for AD/Groups and Sale Led Process.</li></ul>

 

Need to convert this data to

 

Key Deliverables Update:

• Global Expansion - Transact with Credit Card PPOR GA date = Jul-2. Team will continue to identify any efficiencies possible.
• CSP+BO teams have have provided PPOR and SWAG delivery dates for key items like MFA, GDPR, PO, Sales Led process, AD/Groups and other stories according to backlog priority. Services readout was completed Apr-16 with followups due this week for AD/Groups and Sale Led Process.

 

Thanks in advance...

You mean you want Oracle to act like a web browser and parse html?

What you show as the desired output is not "normal" text, it is formatted text.

How would you like SQL to produce an output with text, where some text is underlined? Have you even seen anything like that?

This is a reporting issue. Send the clob to something that can parse and render html. A web browser, a reporting tool, a Word document.

It isn't really an Oracle question.

58d5e9e1-b454-4507-a2d3-36f815435774 wrote:

 

If this is challenging we want to replace <p><u> etc to any readable format .

You can use the replace function to replace strings in strings.

eg

select replace('<p>Remove some things</p>','<p>') from dual

Will replace the <p> with nothing, so you can nest that function with all the different things you want to remove.

If you want to remove all things that look like xml tags then you can use regular expressions, something like

select regex_replace('<p>Remove some things</p>','</?\w+\s*/?>') from dual;

Might do the trick, but obviously more complex xml tags might not be spotted.

This is a client-side thing, nothing to do with Oracle. Just use any text field that can be html-enabled in your client. Both Java and .NET have plenty of options, there's basically nothing you have to do on the database side.

What tool are you using for reporting?

58d5e9e1-b454-4507-a2d3-36f815435774 wrote:

 

Over the net i found similar issue but solution is not posted.

 

https://support.oracle.com/knowledge/Oracle%20Cloud/1953480_1.html#FIX

Oracle Support is a paid for service, if you aren't paying then you can't read the support notes. Also, if this is for use in BI Publisher then you need to ask in a more relevant space.

58d5e9e1-b454-4507-a2d3-36f815435774 wrote:

 

Tableau

Mark this thread as ANSWERED & go post to new forum below

https://community.tableau.com/community/forums/content

58d5e9e1-b454-4507-a2d3-36f815435774 wrote:

 

Tableau

I work with Tableau and that's definitely not an Oracle thing (though what AndrewSayer posted would be rudimentary way to manipulate the HTML).  As suggested by others, Tableau forum should be able to answer your question.