-
1. Re: Convert CLOB data which is having html pseudo code to normal text
jaramill Jun 17, 2019 7:24 PM (in response to 58d5e9e1-b454-4507-a2d3-36f815435774)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.
-
2. Re: Convert CLOB data which is having html pseudo code to normal text
AndrewSayer Jun 17, 2019 7:29 PM (in response to 58d5e9e1-b454-4507-a2d3-36f815435774)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?
-
3. Re: Convert CLOB data which is having html pseudo code to normal text
mathguy Jun 17, 2019 7:34 PM (in response to 58d5e9e1-b454-4507-a2d3-36f815435774)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?
-
4. Re: Convert CLOB data which is having html pseudo code to normal text
58d5e9e1-b454-4507-a2d3-36f815435774 Jun 18, 2019 6:28 AM (in response to AndrewSayer)Yes i would like to convert the text to formatted text .
-
5. Re: Convert CLOB data which is having html pseudo code to normal text
58d5e9e1-b454-4507-a2d3-36f815435774 Jun 18, 2019 6:40 AM (in response to AndrewSayer)If this is challenging we want to replace <p><u> etc to any readable format .
-
6. Re: Convert CLOB data which is having html pseudo code to normal text
Paulzip Jun 18, 2019 6:41 AM (in response to 58d5e9e1-b454-4507-a2d3-36f815435774)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.
-
7. Re: Convert CLOB data which is having html pseudo code to normal text
AndrewSayer Jun 18, 2019 7:00 AM (in response to 58d5e9e1-b454-4507-a2d3-36f815435774)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.
-
8. Re: Convert CLOB data which is having html pseudo code to normal text
Stefan Jager Jun 18, 2019 7:19 AM (in response to 58d5e9e1-b454-4507-a2d3-36f815435774)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.
-
9. Re: Convert CLOB data which is having html pseudo code to normal text
58d5e9e1-b454-4507-a2d3-36f815435774 Jun 18, 2019 9:36 AM (in response to 58d5e9e1-b454-4507-a2d3-36f815435774)Over the net i found similar issue but solution is not posted.
https://support.oracle.com/knowledge/Oracle%20Cloud/1953480_1.html#FIX
-
10. Re: Convert CLOB data which is having html pseudo code to normal text
John_K Jun 18, 2019 10:26 AM (in response to 58d5e9e1-b454-4507-a2d3-36f815435774)What tool are you using for reporting?
-
11. Re: Convert CLOB data which is having html pseudo code to normal text
AndrewSayer Jun 18, 2019 11:13 AM (in response to 58d5e9e1-b454-4507-a2d3-36f815435774)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.
-
12. Re: Convert CLOB data which is having html pseudo code to normal text
58d5e9e1-b454-4507-a2d3-36f815435774 Jun 18, 2019 12:34 PM (in response to John_K)Tableau
-
13. Re: Convert CLOB data which is having html pseudo code to normal text
John Thorton Jun 18, 2019 12:41 PM (in response to 58d5e9e1-b454-4507-a2d3-36f815435774)58d5e9e1-b454-4507-a2d3-36f815435774 wrote:
Tableau
Mark this thread as ANSWERED & go post to new forum below
-
14. Re: Convert CLOB data which is having html pseudo code to normal text
jaramill Jun 18, 2019 1:54 PM (in response to 58d5e9e1-b454-4507-a2d3-36f815435774)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.