HCM Extract BIP report delivery handling of special XML Characters

Hello All,

We have a requirement from a client to pull all of the Talent Profile items from the HRT_PROFILE_ITEMS table. when creating the extract we noticed that in the table there were many instances of special characters that were occurring. Some of these characters consisted of &lt; or &amp for their respective XML characters when they were extracted from the CLOB items in the table. In the table these would be < and & respectively. Im wondering how we can handle characters such as these from a clob but leave them as < or &. We are taking this data and