can you change a character in an element???

[tburrows]

I receive an xml file that has the following structure:
<datatable>
<jmmain_archrg>
<book_id>
<bondstatus>
<bondamt>
<fel_misd>
<chrgdesc>
</jmmain_archrg>
</datatable>

The return is about 200-300 records. In chrgdesc, in a few of the records they will contain < or & charaters. Is there a way to go in and have it changed to &lt; or &amp; ??? Our IT dept won't change the oracle table where the information comes from.

Thanks

 

[harebrain]

I ran into the same problem receiving data from an outside source. With Unix, the easiest way to get around it is to run the data through a simple sed script:

/\&/s//\&/g
/\</s//\</g

HTH