Answered

replacing newline

(1) Share

Report

Posted on by Paul1

I'm trying to replace newline \n with an * using the following compose @replace(body('Html_to_text'),'\n','*'). Nothing happens, I have tried several variation of this function /\n /\n/ "/n" ..

Categories:

Using flows

I have the same question (0)

All responses (10)

Answers (1)

v-micsh-msft on at

Like (0)

Report
Hi @Paul1,

Could you please share your flow configuration in a screenshot?

The replace function would work for string, and if you would like to replace the CRLF code into "*", I think that may not be available through the replace function.

You may take a try with the code below:

@replace(body('Html_to_text'),char(13),'*')

Char(13) here means the newline (CR).

See if it would work in this way.

Regards,

Michael

Was this reply helpful? Yes No
Verified answer

Paul1 23 on at

Like (6)

Report

Mike, thanks but the "Char()" function is not supported. Although I figured it out, you have to LITERALLY put the new-line in the FLOW in single quotes. This works:

@replace(body('Html_to_text'),'
','*')

Was this reply helpful? Yes No
Community Power Pla... on at

Like (3)

Report

Thanks Paul, it was driving me mad trying to find a way of doing this and your post pointed me in the right direction.
I couldn't get it to work exactly as you did but instead I intitialised a variable - which I called "crlf" - at the top of the Flow. I set that to a literal carriage return as you did (by pressing the Enter key) and then used the variable in the "replace" function as follows: (I had a "Data Operations - Compose action called "Message" which contained some Sharepoint list multiline plain text columns which I wanted to format properly within a HTML email, so needed to replace line endings with the <br /> tag).

This is as entered in the expression editor (so no @ symbol): replace(outputs('Message'),variables('crlf'),'<br />')

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @Anonymous,

I'm facing the same issue, try to replace the new lines with a " * ".
Can you provide a screenShot please of the flow, soory i didn't get the solution that you mentioned.

Thank you.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (5)

Report

Hi Marwa1,
The screenshot below is an example of replacing newlines with asterisks as you were trying to do.
In the "Initialize variable" step Value looks empty but in fact it contains a newline character (entered by pressing the Enter key).
In the "Compose 2" step the expression in full is
replace(outputs('Compose'),variables('crlf'),'*')

Running the flow gives the following output:

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

Hi @Anonymous, Sorry the second set of screenshots above is jumbled - hope they make sense.

Was this reply helpful? Yes No
Paul1 23 on at

Like (0)

Report

CollinB, your solution is much more elegant, then mine..!

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@Paul1 - I'm not sure about that ! 🙂

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

worked perfectly!!!

Was this reply helpful? Yes No
malbornoz 11 on at

Like (0)

Report

This worked perfectly for me, thanks!

For those who are looking what that 'Compose' action is in the spanish version look no more, it's 'Redactar' under 'Operación de datos'.

Was this reply helpful? Yes No