Parsing text can be somewhat tricky with Microsoft Power Automate or Azure Logic Apps. Recently I needed to strip out end-of-line characters (CR/LF) from a text string.
This task actually proved to be a bit more challenging than I had expected… However in this post I’ll share the solution that I found and ultimately ended up using.
The following expression will remove the end-of-line characters from text strings in your Power Automate or Azure Logic Apps workflow.
uriComponentToString(replace(uriComponent(<YOUR_TEXT_HERE>), '%0A', ''))
To demonstrate this, we have a Power Automate workflow that does the following:
- Extracts the plain text from a text string containing HTML content.
- Writes the output to a text file.
- Writes the output to another text file, however in this file, the end-of-line characters are removed by using the above expression.
I hope this solution has helped you. If you find an alternative solution, feel free to post it below to help others out there.