We can remove empty lines by appending a formula at the back of the datapill
[Datapill].gsub(/\n+/, "\n").strip
gsub is a formula that replaces a specific character in a string with another one.
strip removes leading and trailing white space in a string.
Documentation on workato formulae can be found here:
\n+ and \n are regex expressions
Search for regex expressions here: https://regexr.com/
Send us a ticket, we will try our best to assist you with your problem
Saul Macht
Remove empty lines in data
I have many blank lines that show up in some text output. It is not a problem, but if I could find a way to clean some of the whitespace that would look much better. Any tips?