This discussion is archived
5 Replies Latest reply: Mar 1, 2013 9:28 AM by AlexAnd RSS

Special Characters in XML Publisher PDF Output

968711 Newbie
Currently Being Moderated
Hi,

I'm printing "Long Text" in report output in every line based on tab.
Report output is having special characters like \n.
I was using below to print in next line, any suggestions for removing \n.

Below is what was happening:
===================
RDF:
=====
lv_notes := replace(:CF_LONG_TEXT_DESC, chr(9), ' ') ;
lv_notes1 := replace(lv_notes, chr(10), ' ') ;
lv_notes2 := replace(lv_notes1, chr(13), ' ') ;

XML
===
<CF_LONG_TEXT_desc>
Initial Billing Amount: $549,180.00 \n \n Computation: \n a) Estimated Number of Full-Time Students: 12,000 \n
b) Estimated Number of Calendar Days: 113 \n
c) Calendar Date (From - To): 1/18/2011 - 5/10/2011 \n
d) Multiply by: $0.81 \n
e) Estimated Total Costs: $1,098,360.00 \n
f) Initial Billing Amount represents 50% of Estimated Total Costs. \n

\n \n
If you have questions about your invoice please contact Darud Akbar at (312) 681-2724.
</CF_LONG_TEXT_desc>

PDF Output
==========
Initial Billing Amount: $549,180.00 \n \n Computation: \n a) Estimated Number of Full-Time Students: 12,000 \n
b) Estimated Number of Calendar Days: 113 \n
c) Calendar Date (From - To): 1/18/2011 - 5/10/2011 \n
d) Multiply by: $0.81 \n
e) Estimated Total Costs: $1,098,360.00 \n
f) Initial Billing Amount represents 50% of Estimated Total Costs. \n

\n \n
If you have questions about your invoice please contact Darud Akbar at (312) 681-2724.

Thanks.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points