Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to avoid HTML tags in CSV output

DeepakJMay 17 2010 — edited Oct 20 2010
Hi,

I have a Interactive Report, some of the columns are links which are derived from functions as shown below.

function1 (p1) - this function will return a url something like
          '<a href=f?p=........>'||p1||'</a>';
select col1, col2, function1(col3) from table1
Report Output
11	22	_33_(link)
CSV Download Output
11	22	<a href=f?p=........>33</a>
Report output is perfectly fine and links are also displayed correctly..*no issues*
BUT when I download this as a CSV output...I am getting all the html tags *< a* along with href=..f?p=... */ a >* in the CSV file
Is there any way to avoid these html tags in the CSV download file.

Thanks,
Deepak

Edited by: Deepak_J on May 17, 2010 3:44 PM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 17 2010
Added on May 17 2010
11 comments
2,272 views