Search icon CANCEL
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Automate It with Zapier

You're reading from   Automate It with Zapier Boost your business productivity using effective workflow automation techniques

Arrow left icon
Product type Paperback
Published in Aug 2021
Publisher Packt
ISBN-13 9781800208971
Length 618 pages
Edition 1st Edition
Tools
Arrow right icon
Author (1):
Arrow left icon
Kelly Goss Kelly Goss
Author Profile Icon Kelly Goss
Kelly Goss
Arrow right icon
View More author details
Toc

Table of Contents (29) Chapters Close

Preface 1. Section 1: Getting Started with Zapier
2. Chapter 1: Introduction to Business Process Automation with Zapier FREE CHAPTER 3. Chapter 2: Preparing to Automate Your Processes 4. Chapter 3: Building Your First Automated Workflow (Zap) 5. Chapter 4: Managing Your Zaps 6. Chapter 5: Troubleshooting and Handling Zap Errors 7. Section 2: Customizing Your Zaps with Built-in Apps by Zapier – Functionality and Practical Uses
8. Chapter 6: Creating Multi-Step Zaps and Using Built-In Apps 9. Chapter 7: Getting Started with Built-In Apps 10. Chapter 8: Built-In Communication Apps 11. Chapter 9: Exploring Built-In Apps for Extracting and Compiling Data 12. Chapter 10: Other Useful Built-In Apps by Zapier 13. Chapter 11: Advanced Built-In Apps by Zapier 14. Chapter 12: Managing Your Zapier Account with Built-In Apps 15. Section 3: Using the Features of the Formatter by Zapier Built-In App
16. Chapter 13: Formatting Date and Time 17. Chapter 14: Formatting Numbers 18. Chapter 15: Text Formatting Functions in Zapier – Part 1 19. Chapter 16: Text Formatting Functions in Zapier – Part 2 20. Chapter 17: Zapier's Utilities Functions 21. Section 4: Getting the Most Out of Zapier – Business Automation Examples
22. Chapter 18: Automating Your Marketing Processes 23. Chapter 19: Automating Your Sales Processes 24. Chapter 20: Automating Your Operations Processes 25. Chapter 21: Automating Your Finance and Reporting Processes 26. Chapter 22: Tips, Tricks, and Best Practices to Enhance Your Productivity 27. Chapter 23: Challenge Your Problem-Solving and Zap-Building Skills 28. Other Books You May Enjoy

Removing whitespace

Sometimes strings of text may not have been edited in the way we need to be able to use them 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.

Here is an example of when you can use this transform option:

  • You might ask job seekers to send in applications by completing a webform. There might be formatting issues with the webform, presenting the data with large whitespace blocks before or after the body of parts...
lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at €18.99/month. Cancel anytime