APEX

Hi there,

I have a CLOB field in my application that is using HTML text area and that is working fine. I have a report displaying some information including this field and again this works fine too.

The problem is that, the user wants to be able to be to export this report into Excel. So I have used Scott's Custom Export to CSV PL/SQL process to do this:

http://spendolini.blogspot.com/2006/04/custom-export-to-csv.html

But when I open the excel spreadsheet it contains the HTML tags like 'p>' 'strong>' etc. Is there anyway I can strip these out?

I have tried using ctx_doc.filter('GUIDANCE_NOTES_IDX', 1, 'filter', 1, TRUE) but this is still displaying the tags.

Does anybody have any ideas?

Cheers,
Paul.

Message was edited by:
paulgall

Message was edited by:
paulgall