Passing Multi-Line String Through Queue

[cknight5 (Cam Knight)]

Hoping someone can help me with a rather specific issue which I can’t find an answer to.

I want to grab a multi-line String value, obtained from a single cell in an Excel file, and pass it through an Orchestrator Queue to use as an input later in my process. In all my attempts, the String seems to get collapsed to a one-line string when passed through the Queue. Is there a way to get the String to hold its multi-line value when being passed or retrieved from the queue?

Ex Value just for discussion’s sake:

“Line 1
Line 2
Line 3”

When my process runs, it would output this post-queue as “Line1Line2Line3”

Any help would be much appreciated! Thanks!

[Mr_Meeseeks (Dan Fishkin)]

Could you show us a screenshot of the locals panel after performing the read cell activity? There is definitely a way to accomplish what you are trying to do!

[Mr_Meeseeks (Dan Fishkin)]

@cknight5 you can use the join and split command to make these a little easier to work with (the below assumes you are OK with using a comma instead of a new line).
credits to @Yoichi

Separate String on newlines in Excel

If you press ALT + Enter on excel you can write in the same cell but on a different line. I want to know how I can separate each new line and save it as it’s own string.

Join(split(cellText, vbLf),“,”)

[cknight5 (Cam Knight)]

Thank you for the recommendation, this worked perfectly.

I had a feeling the answer was somewhere in substituting the NewLine value with a placeholder while I passed it through the queue. Thank you for laying it out so clearly.