Current Appian striphtml() function only stripping html entity number for few, but html entity name still remains in the given text. Html Decode

Certified Senior Developer

Do we have any Html decode function other than stripHtml? or any regex function to use ?

Example of My current String which I get from Portal and it will be saved in DB as

"I’m Appian resource.  Any other existing–resource?"

If I use striphtml("I’m Appian resource.  Any other existing–resource?")

I am getting same output -> "I’m Appian resource.  Any other existing–resource?"

If I use

merge({ "’", "–" }, { "'", "-" })

Then I will get proper result -> "I'm Appian resource.  Any other existing-resource?"

But I can't predict only 2 html entity names. There are many, that I need to convert and display in a!paragraph field.

  Discussion posts and replies are publicly visible

Parents Reply
  • 0
    Certified Lead Developer
    in reply to Sushma Rathnaiah

    Below a simple way to substitute multiple string in one go. Just add any missing HTML entity and its replacement. Perform this to cleanup when loading the data.

      local!html: "I’m Appian resource.  Any other existing–resource?",
          {"& n d ash;", "& n b sp;", "& r s quo;"},
          {"-", " ", "'"}

    I had to add some spaces to the HTML entities to please this editor here.

  • 0
    Certified Senior Developer
    in reply to Stefan Helzle

    Right now I am using same thing from yesterday, but how many we can include by seeing one by one 90k+ records. Yesterday I did some random search in DB and able to add few character sets. 
    But there are Many. Looking something smarter.

    There is also one more issue as per current Appian Documentation for the stripHtml() function. It mentions "Changes the provided HTML string into a plain text string by converting <br><p>, and <div> to line breaks, stripping all other tags, and converting escaped characters into their display values" 
    But It is just adding space, not 'New line'