How to decode html encoded text?

user_3932615 0
Viewed 430

I have a column in a file that contains html encoded text. I would like to decode this column to text before saving it to the database. What is the best method to do this in data factory?

azure-data-factory-2 azure-data-factory
1 Answers

It seems that decode function in ADF can't decode html directly.

enter image description here

ADF sql server connector supports execution of stored procedure:https://docs.microsoft.com/en-us/azure/data-factory/connector-sql-server#invoke-a-stored-procedure-from-a-sql-sink

You could refer to below threads to decode html with User-Defined Function in sql server:

1.SQL Server: HTML Decode based on the HTML names in a String input

2.Is there any way to do HTML decode in SQL Server?

Then execute function in stored procedure,please refer to this link.

user_81989460
Related