Converting HTML entities to Unicode Characters

• vijay.singh 14112

  SSCommitted

  Points: 1589

  More actions

  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

• Lowell

  SSC Guru

  Points: 323522

  More actions

  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!

• vijay.singh 14112

  SSCommitted

  Points: 1589

  More actions

  October 29, 2012 at 8:09 am

  #1553734

  Thanks a lot Lowell.:-)

  Regards,

  Vijay

• russellz

  Grasshopper

  Points: 21

  More actions

  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!