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?

Lee Meng Ran

said over 4 years ago

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:

https://support.workato.com/support/solutions/articles/1000173152-formula-mode-list-of-common-formulas-operators-and-how-to-use-them

\n+ and \n are regex expressions

Search for regex expressions here: https://regexr.com/

Still can't find your solution?

Send us a ticket, we will try our best to assist you with your problem