Split at \r\n\r\n

(1) Share

Report

Posted on by JimmyW

2,563

Im trying to split an email body preview at \r\n\r\n but the split does not seem to work.

split(body('Parse_JSON')?['bodyPreview'], '\r\n\r\n')

I just end up with one line, nothing is split

Categories:

Building flows

I have the same question (0)

All responses (10)

Answers (1)

Verified answer

efialttes 14,756 on at

Like (8)

Report
Hi!

Guess this same problem happens when dealing with CSV files.

If so, some threads in this same community discussing this other topic, like

https://powerusers.microsoft.com/t5/Building-Flows/Split-method-parse-csv/td-p/514345

Use uriComponent() function to convert the string into URI code, then use replace() function to replace line separator("%0D%0A") and add ";" instead, then use decodeUriComponent() to decode it ... Then use the split() function to create an array: split(outputs('Compose'),';')

Hope this helps

2 people found this reply helpful.

Was this reply helpful? Yes No
_Ken 120 on at

Like (5)

Report
\r can be addressed as decodeUriComponent('%0D')
\n as decodeUriComponent('%0A')
One simple solution with multiple \r\n\r\n as follows:

split(body('Parse_JSON')?['bodyPreview'], decodeUriComponent('%0D%0A%0D%0A'))

Was this reply helpful? Yes No
john_dawson 8 on at

Like (1)

Report

Thanks for that; worked for me - and only thing that did, after trying other suggestions

Was this reply helpful? Yes No
FreeRangeDingo 114 on at

Like (1)

Report

Hi Ken,
I sent my email body to a variable and wrote the following expression in a compose action.
split(variables('EmailBody'), decodeUriComponent('%0D%0A'))
This works. I see the right data in the right format/line spacing coming out of the compose.
However, when I then take the output of the compose and put it into a Azure DevOps action to create a work item, when the work item gets to ADO, all the line spacing is gone and it's one big paragraph again. Any ideas on this?

Was this reply helpful? Yes No
_Ken 120 on at

Like (0)

Report

Quick test of the ADO 'Create a Work Item' action seems to indicate it differs from field to field.
Description - seem to prefer a html <br>
Repro Steps - seem to truncate any line breaks
Best way to find out is looking at the Power Automate run results input/output and experiment with different line break types.

Was this reply helpful? Yes No
FreeRangeDingo 114 on at

Like (1)

Report

This is what worked.

Was this reply helpful? Yes No
_Ken 120 on at

Like (1)

Report

Awesome - nice solution.
Will add that to my list of script snippets.

Was this reply helpful? Yes No
BellaM 14 on at

Like (0)

Report

Thank you so much efialttes!

Was this reply helpful? Yes No
BellaM 14 on at

Like (0)

Report

Thank you so much efialttes!

Was this reply helpful? Yes No
IanIrvine 29 on at

Like (0)

Report
I Spent an hour arguing with Microsoft Copilot about this then noticed in the code view in Power Automate that when I was splitting by '\r\n' the code was '\\r\\n'

However your approach worked first time

trim(split(split(triggerOutputs()?['body/body'], 'Depot: ')[1], decodeUriComponent('%0D%0A'))[0])

reading the body of my email and splitting the string up based on the text after 'Depot: ' and before the \r\n

Thanks again, this one has been bugging me for a few hours

Was this reply helpful? Yes No