Book Image

Robotic Process Automation with Automation Anywhere

By : Husan Mahey
Book Image

Robotic Process Automation with Automation Anywhere

By: Husan Mahey

Overview of this book

With an increase in the number of organizations deploying RPA solutions, Robotic Process Automation (RPA) is quickly becoming the most desired skill set for both developers starting their career and seasoned professionals. This book will show you how to use Automation Anywhere A2019, one of the leading platforms used widely for RPA. Starting with an introduction to RPA and Automation Anywhere, the book will guide you through the registration, installation, and configuration of the Bot agent and Control Room. With the help of easy-to-follow instructions, you’ll build your first bot and discover how you can automate tasks with Excel, Word, emails, XML, and PDF files. You’ll learn from practical examples based on real-world business scenarios, and gain insights into building more robust and resilient bots, executing external scripts such as VBScripts and Python, and adding error handling routines. By the end of this RPA book, you’ll have developed the skills required to install and configure an RPA platform confidently and have a solid understanding of how to build complex and robust, yet performant, bots.
Table of Contents (20 chapters)

Manipulating strings

When dealing with data, it isn't always in the format we need it to be in. Developers will often write routines to manipulate data so that it suits its purpose. A number of actions are available to help us manipulate data. This walk-through will give you the skills you need to build effective data manipulation routines. In the example, you will read a single string that consists of a few names. This is the format the data is initially available in. The bot is tasked with manipulating it to produce a CSV file. This file will have separated all the names into two columns. The first column will contain the surname in capitals, while the second column will contain the forename and any initials. The forename will be in Proper case, while the initials will be in uppercase.

While working through this walk-through, we will look at the following string manipulation actions:

  • Replace
  • Find
  • Substring
  • Split
  • Trim
  • Uppercase
  • Lowercase
  • ...