There may be a bug in the way Orchestrator matches the new line character (\n). Sometimes it just does not find the new line! After a bit of research, I discovered that you can use the Expand Fields activity and match new lines the built-in Data Manipulation function like so:
[lower(‘
‘)]
This is all you need to ‘declare’ the newline character.
Here is what my Expand Fields activity looks like:
