Power Platform Community Forum Thread Details

Hello,

Can anybody please help me to replace "'\u0005'," with nothing? I tried a few ways did not work. Please see below.

I have a flow that read an excel sheet and generates multiple docs, but on the description, there are some characters Power Automate does not like.

Then started debugging isolating work description

1st I tried using all base64 options, and it works but my description is unreadable.

2nd I tried to replace characters and rejoin it (Saw this one on the Power Automate community) but did not do anything

Add all the characters 
range(0,length(outputs('Isolate_Work_Description')))
if
(
 contains(outputs('UnwatedCharacters'), substring(outputs('Isolate_Work_Description'), item(), 1)), 
 '', 
 substring(outputs('Isolate_Work_Description'), item(), 1)
) 

join(body('Select'),'')

3rd I tried replacing the value (did not work, I am trying this option, compare 2nd one this is I think)

at beginning I tired initializing variable it has quote, "\u0005" and "'\u0005'" (both ways)

replace(string(outputs('Isolate_Work_Description')),variables('Character'),'')

basically, I tried all the below options found on the net,

https://powerusers.microsoft.com/t5/Building-Flows/What-is-quot-u0002-hexadecimal-value-0x02-quot-and-why-is-it/td-p/924078

https://www.youtube.com/watch?v=Xb4psa35oWM

https://www.tachytelic.net/2020/10/remove-unwanted-characters-power-automate-flow/

Can anybody please tell me what's missing and why it's not replacing? I have been working on this for a week now.

Especially 3rd option, why is not replacing value? Am I missing something