topic Re: Put CSV Output on New Lines ? in Workato Pros Discussion Board

Put CSV Output on New Lines ?

dunncrew — Thu, 12 Oct 2023 21:07:36 GMT

I am reading 1 text field from a SQL Server select rows and want to send them in an email. Currently, it puts all the records on one line, but I want each record on a new line. Any suggestions ? I tried to force a "New line" break, but no luck.

See Screen-shots and result data (3 records sample) below.

Instead of this

10/11/2023 10:16 Jones, Mary, Computer Room , 10/11/2023 10:54 Smith, Frank, Computer Room , 10/11/2023 15:56 Amos, Henry, Computer Room

I want

10/11/2023 10:16 Jones, Mary, Computer Room

10/11/2023 10:54 Smith, Frank, Computer Room

10/11/2023 15:56 Amos, Henry, Computer Room

Re: Put CSV Output on New Lines ?

gary1 — Thu, 12 Oct 2023 21:26:07 GMT

When you pluck a single field, the result is a flat array of values, so using to_csv creates a CSV with a single row (no line breaks).

If you add a second value to your pluck it will make a two-dimensional array (an array of arrays), and to_csv will add line breaks between each secondary array.

If you don't want to pluck a second value, you can drop to_csv and use [rows].pluck('output').split('\n')

Re: Put CSV Output on New Lines ?

dunncrew — Thu, 12 Oct 2023 22:08:59 GMT

Thanks. I think the output is correct when I do this:

But after the next step to send the email

I get this error.

Also, It looks like I can "trick" it into making a 2 dimensional array by PLUCKing a blank instead of a 2nd field, but it puts a comma off to the right to separate the imaginary 2nd blank field from valid field 1

P.S. Thanks for all your help the last few days !

Re: Put CSV Output on New Lines ?

gary1 — Thu, 12 Oct 2023 22:10:02 GMT

Try setting the body input to text and not formula mode.

No problem! Happy to help : )

Re: Put CSV Output on New Lines ?

dunncrew — Thu, 12 Oct 2023 22:26:20 GMT

No error, but my email result is this:

[["10/11/2023 10:16 Jones, Mary, Computer Room ", "10/11/2023 10:54 Smith, Frank, Computer Room ", "10/11/2023 15:56 Amos,Henry, Computer Room "]]

Re: Put CSV Output on New Lines ?

gary1 — Fri, 13 Oct 2023 00:24:33 GMT

D'oh! My bad. Try this:

[rows].pluck('output').join('\n')

Re: Put CSV Output on New Lines ?

dunncrew — Fri, 13 Oct 2023 13:58:29 GMT

it treats the '\n' as a character string, not a line break. Do I need square brackets [ ] or something to code it as a line break ?

Re: Put CSV Output on New Lines ?

gary1 — Fri, 13 Oct 2023 15:04:00 GMT

In the Outlook action, is the body format set to text or HTML? "\n" should work if it's set to text.

If it's HTML, you'll need this:

[rows].pluck('output').join('<br>')

Re: Put CSV Output on New Lines ?

dunncrew — Fri, 13 Oct 2023 17:09:19 GMT

Thanks. <br> with HTML worked.