using field with embedded new lines loses the new lines when used as an email body

[Mike7M]

I have a daily generated text file that I would like to use as the email body, but it seems that new lines are ignored using a field with embedded new lines as an email body.

Both the Python tool and the Summarize tool result the same one-liner ignoring the \n separator in the email body but the browser tool recognizes the field with embedded new lines!

here is the received email body:

test test Daily automation

instead of:

test

test

Daily automation

I looked at the report text tool but could not see how to read in a text file or read from a field

Any trick to read a text file into an email body without losing the CR LF at the end of each line?

Thank you!

[FinnCharlton]

@Mike7M here are some links that might be useful:

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Adding-a-new-line-within-text-...

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Working-with-wanted-line-break...

[Mike7M · Accepted solution]

Thank you! using the Summarize tool with a <br /> separator solved the issue