Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: how do i convert HTML entities in fields?

  1. #1
    Join Date
    Aug 2009
    Posts
    14

    Default how do i convert HTML entities in fields?

    I got html entities in fields like "ä" or "ß".
    They come from a mysql database. How can i convert these values? "ä" to "ä" ...

  2. #2

    Default

    With a little JS :-)

    Samatar
    Attached Files Attached Files
    Samatar

  3. #3
    Join Date
    Aug 2009
    Posts
    14

    Default

    thx.

  4. #4
    Join Date
    Jun 2013
    Posts
    24

    Default

    Hi, this is very helpful. Mostly. I am finding that common enties such as those used in html tags work great. However in the same field, same stream of data, there are entities that don't get unescaped, such as ’ – &rdquo etc.

    Seeing that this is a topic almost 7 years old, is there a better way now? Or a way of forcing this technique to be more aggressive?

  5. #5
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    Try Calculator step (category Transform) function "Unescape HTML content".
    So long, and thanks for all the fish.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.