Thanks for any help. I am not sure if this is the right place to put this but I am working in APEX.
I am using APEX 4.2.
I am trying to create a report from data within Apex. I created my rtf template in word. The issue is one of the items contains data that has special charcters such as (&, :,@,()) in the field and when I try running the query the rtf template gives me an error.
Is there a way to escape all the characters so I can put the data in as is. When i remove that field the report works fine and the charcters that are in the field are the only issue that I can see.
look at the apex api reference apex_escape fro the ways you can escape date.
If the question is answered please change it to answered.