Solved: "HTML number" translation into Ascii

efialttes · ‎02-28-2018

Hi all!

Is there any WDL function / action component / trick that can help me to translate any HTML number (https://www.ascii.cl/htmlcodes.htm) into its corresponding Ascii characters?

For example, I am getting a JSON as follows:

{
"Title": "Jornada ‘Familia 4.0’",

"ULR": "http:/..."

}

Thank you in advance!

Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!

Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!

v-yuazh-msft · ‎03-02-2018

Hi @ efialttes,

Translating HTML number to its corresponding Ascii characters is not supported in Microsoft flow currently.

If you would like this feature to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

Regards,
Alice Zhang

View solution in original post

v-yuazh-msft · ‎03-02-2018

Hi @ efialttes,

Translating HTML number to its corresponding Ascii characters is not supported in Microsoft flow currently.

If you would like this feature to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

Regards,
Alice Zhang

degvalentine · ‎09-05-2019

Brute-force nesting of "replace" functions will work.

replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(
variables('myJson')['Title'],
'&#48;', '0'), '&#49;', '1'), '&#50;', '2'), '&#51;', '3'), '&#52;', '4'), '&#53;', '5'), '&#54;', '6'), '&#55;', '7'), '&#56;', '8'), '&#57;', '9')

Replace "variables('myJson')" with whatever output has your JSON body.