Post reply

Converting HTML entities to Unicode Characters

  • October 29, 2012 at 7:18 am

    #264080

    Hi Experts,

    I am here with another question. I have a string where i have some HTML entities in between string(Please find the HTML entities below). I need to convert that to Unicode Character. Please help me in resolving this problem.

    ü

    ñ

    Í

    è

    ë

    Ó

    Ú

    á

    º

    °

    ò

    í

    •

    Ñ

    ‐

    –

    ó

    É

    é

    fl

    …

    Á

    ú

    ’

    fi

    Thanks in Advance.

    Regards,

    Vijay

  • October 29, 2012 at 7:56 am

    #1553727

    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

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • October 29, 2012 at 8:09 am

    #1553734

    Thanks a lot Lowell.:-)

    Regards,

    Vijay

  • January 19, 2018 at 2:41 pm

    #1976590

    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!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply