Remove /r/n and /r from flow.

(0) Share

Report

Posted on by Watkins

Hi All,

I have been working on this flow and run into a few problems which by the help of some amazing people on here have been fixed. This is the latest problem I am facing.

So everything is working correctly, but in order for this to then be uploaded to our other software, the \r and \r\n that is showing up on the create file output would need to be removed, is there a way to do this?

Note that this is the way the data comes in and I can't change that as its coming from a piece of limited functionality hardware, can this be done with a replace at the end of the flow or would there need to be something beforehand to prevent the /rn and /r from showing? as its interfering with the data upload.

So I would just need to remove the \r and the \r\n so its not interfering with our data upload can provide any other screenshots if needed.

Thanks,
Watkins.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Watkins

Try using the replace expression.

replace(replace('Here replace your string', '\r', ''), '\n', '')

Was this reply helpful? Yes No
Watkins 70 on at

Like (0)

Report
Copy link

Link copied!

Hi @abm ,

So I tried to do this with a few variations and took the output from 'replace_brackets' this is what happened,

replace(replace('replace_brackets', '\r', ''), '\n', '')
Output is just replace_brackets
replace(outputs('replace_brackets', '\r', ''), '\n', '')
Returns the below error,replace(outputs('replace_brackets'),'\r','')
To see if just trying to replace one works, does work but doesn't replace. See screenshot of output below.

I did also try 'Create_CSV_table' still didn't work. The \r and \r\n only show up on the Create CSV table input and the create file output, below is how the data looks before it goes through the flow just saved as a CSV file and opened in notepad. I'm not sure how to remove the \r,\rn from the flow.

Thanks,
Watkins.

Was this reply helpful? Yes No
Suggested answer

NH-09041120-0 4 on at

Like (1)

Report
Copy link

Link copied!
Quite an old post, I know, but for anyone who's still struggling with this here's a solution I found on Stack Overflow: Remove \r from a power automate string - Stack Overflow

Use Replace() function and denote \r as decodeUriComponent('%0A')

Sample:

replace('string\r',decodeUriComponent('%0A'),'')

Here are the keys:

decodeUriComponent('%0A') => \r

decodeUriComponent('%0D') => \n

2 people found this reply helpful.

Was this reply helpful? Yes No