Removing whitespace
Sometimes, strings of text may not have been edited in the way we need so that they can be used in other steps in our workflows. This is often the case when certain apps present data in a certain way with blank character spacing before or after the text. In these scenarios, if you want to alter the format of the text so that no whitespace exists at the beginning or end of a string of text, you can use the Formatter by Zapier Text action event with the Trim Whitespace transform function to achieve this. Microsoft Excel users will recognize the similarity between using this Zapier functionality and the TRIM
formula in a Microsoft Excel spreadsheet to remove whitespace from a string of text.
An example of a situation where you could use this transform option would be when you ask job seekers to send in applications by completing a web form. There might be formatting issues with the web form, presenting the data with large whitespace blocks before or after the body...