Getting escape character while populating data which is in html code

Question

Hi Team,

As part of my process, I am generating a html code using a Stored Procedure via lookup activity. Im getting extra escape characters (") along with my code which breaks the color grading of my output. It would be great if you can help me to sort this issue.

Here im attaching the sample screenshot.

Thanks,

Yashwanth M

Answer 1

Hi
Mutthuluru Yashwanth Sai

If the backslash is the problem, you can use string function replace to replace the escape character using below expression, which replaces backslash with an empty string. So, if you have a text like "color:green"\ then it will get replaced as "color:green"

@replace(activity('Lookup1').output.firstRow['HtmlOutput'],'\\','')

You can use this expression and assign the output to a variable and use that variable in your pipeline in subsequent activities.

Please try and let us know if that helps.

Thanks.