• Lowell - Monday, October 29, 2012 7:56 AM

    i played with something similar, where i was converting from xml/html entities to the unicode? character char definition. the problem was i was using a recursive function, and the #of recursion levels is limited to 100, but of course there are more html entities than that that are defined. because of limitations in the forum, you cannot paste html entities; they get displayed instead, which makes pasting code pointless for issues like this. take a look at this Inline Table Valued Function i played with a while ago; it does most of what you want. XML_To_ASCII.txt (note the array of possible values in the function is the complete list...to get it to work, you need to remove/comment out some of the values so there are only 100 items to replace--much easier to edit and comment out than try to add in something that was missing but you need.) thinking about it deeper, i think the right thing to do would be to create two or more functions, so each one can do 100 find/replaces, until the whole possible collection of html entities are replaced. here's a list of all the entities for refernece: http://www.w3schools.com/tags/ref_entities.asp

    Can you please re-post solution to this one again?
    Thank you!