Dear Community,
in my workflows I have cells which include line breaks. I would like get them to written to a gSheet. With the old "gSheet Input / Output" it worked. Now, with the Google Drive Output, line breaks lead to multiple rows which destroys the whole sheet formatting.
I already tried something like (Attribute1 contains a linebreak), but it did not work:
Replace([Attribute1], '\n", CharFromInt(10))
This actually worked, but i would prefer text instead of writing gSheet formular to a sheet:
'="a"&CHAR(10)&"b"'
Any advice?