replacing newline

[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" ..  

[v-micsh-msft]

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

[Paul1 · Accepted solution]

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'),'

','*')

[Anonymous]

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 />')

[Anonymous]

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.

[Anonymous]

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:

[Anonymous]

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

[Paul1]

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

[Anonymous]

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

[Anonymous]

worked perfectly!!!

[malbornoz]

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'.