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.
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:
Hi @abm ,
So I tried to do this with a few variations and took the output from 'replace_brackets' this is what happened,
Thanks,
Hi @Watkins
Try using the replace expression.
replace(replace('Here replace your string', '\r', ''), '\n', '')