How to remove an Enter from a string

[Anonymous]

Hi.

I'm trying to find some text in files on Sharepoint. For that I used "Send HTTP request to Sharepoint". Once I get Result is shows search in HTML format. I convert it to text, but after that I realize that path to the file contains "enter". And step - get file content  using path failed.

I tried to use "replace", but it didn't help.

[ChristianAbata]

hi @Anonymous  enter is a line break like this

12123123

12312312

that blank space is a line break for me, it is for you the same as enter?

if is yes please use this expression

uriComponentToString(replace(uriComponent(body('Html_to_text')), '%0A', ''))

you can follow more info here https://powerusers.microsoft.com/t5/Building-Flows/Replace-Newline-in-Flow-Expression/td-p/57333

[Anonymous]

@ChristianAbata hi. 

yes. The problem is that when I get a substring from converted text it in some cases shown like:

”https://....../folder 

xxx/filename.pdf”

if I use this substring in get file content it shows error due to line breaker.

i made a test removed it, so line looks like:

”https://....../folder xxx/filename.pdf”

and it worked properly. So I’m looking for a way how to remove that line breaker.

[abm]

Hi @Anonymous 

Use a Split expression then iterate the values and map in next step.

Thanks

[ChristianAbata · Accepted solution]

@Anonymous  please follow this

see when you use uriComponent  you have this %20%0A%0A string that means your like  break. Then you just can replacte this to delete it from your line.

[Anonymous]

Hi, tried your solution, but that didn't work for me.

As a result I got as an input on a second compose -

Path%2FFolder%0AXXXXX%2F2020%2F05%2F103_120520_PP200512-0508418.pdf

Instead of Path/Folder XXXXX/2020/05/103_120520_PP200512-0508418.pdf

[Anonymous]

On a step "get file content using path I added replace function to output from Compose replacing %2F by "/" and it worked 🙂

Thanks 🙂