Remove carriage return (line break) \r\n from string

(0) Share

Report

Posted on by ariccia79

Hi all,

I'm in trouble with removing carriage return from a string in Power Automate.

From Teams I'm using Power Virtual Agent and a user can send a message in two lines (or more).

This message is sent to Power Automate to compose a Json, but I cannot be able to remove the line break.

This is an input example:

Using the expression split(variables('DescriptionParsed'), '\r\n') I can see the output with \r\l

But next, when I "Apply to each item" to replace "\r\n" with empty string to have the text in a row, it doesn't work:

I've also tried without array, using join(split(variables('DescriptionParsed'), '\r\n'), '') but nothing has changed.

I need that

Ciao, ho un problema

con la stampante

will result as

Ciao, ho un problema con la stampante

I've tried a lot of solutions, but nothing is working for me.

How can I remove the new lines??

Thank you

Anna

Categories:

General topics

I have the same question (0)

All responses (7)

Answers (1)

Verified answer

ariccia79 42 on at

Like (11)

Report

I've resolved it! 😭
I can do it in a single line, using
split(MYSTRING, decodeUriComponent('%0D%0A'))
I can split in the right way my string with \r\n

I need to replace them with whitespace to have text in a single row, so I'm using a join

My final expression is:
join(split(MYSTRING, decodeUriComponent('%0D%0A')), ' ')

Was this reply helpful? Yes No
Steve48 431 on at

Like (0)

Report

How do you enter it into the join dialog box

Was this reply helpful? Yes No
ariccia79 42 on at

Like (0)

Report

In MS Teams, you can enter a new line with key ENTER and SHIFT or ENTER and ALT.

Was this reply helpful? Yes No
Steve48 431 on at

Like (0)

Report

Thank you for responding. My interest was really for power automate desktop. I found out that they have an action that will split text on a new one and also an action to join list elements with a space so that solved my problem

Was this reply helpful? Yes No
bu11frogg 130 on at

Like (6)

Report
I had a multiline text column from SharePoint with blank rows (extra line spacing) between each line of text. I tried replace() on the text from SharePoint, and I also tried trim(). Then I found this article, but I could not get the join / split solution (above) to work, either. However, the "decodeURI" part of that expression got me thinking.

I ended up using an expression to encode the original text, then another expression to replace the %0A (my text only had \n for a new line char), then another expression to decode the text again. It works well. Here are the screenshots and expressions if it will help anyone.

The expression from the 1st Compose action is just encoding the text from the original SharePoint item's multiline text field:
encodeUriComponent(outputs('Get_item')?['body/ApprovalText'])

Compose 2's expression replaces 2 newlines ('%0A%0A') with a single newline ('%0A'); you could just replace with '' to get rid of the new line completely:
replace(outputs('Compose'),'%0A%0A','%0A')

Compose 3 just decodes the result of Compose 2 back to "normal" text:
decodeUriComponent(outputs('Compose_2'))

Hopefully that helps someone.

Was this reply helpful? Yes No
aniuafen 19 on at

Like (0)

Report

Very useful thanks ! Tried replacing \n\n with \n and it didn't work even if you could clearly see this in input. Luckily your solution worked

Was this reply helpful? Yes No
jcneto25 6 on at

Like (0)

Report

Life saving tip !!!! Thanks

Was this reply helpful? Yes No