Automate Desktop

Text Manipulation

Chapter 3 | Automate Essentials

See how Automate’s text manipulation actions can easily convert, transform, and extract text for various business processes. Some common text operations involve stripping of characters or white space, converting words to upper or lower case, adding or replacing characters, and calculating character count for the selected text. In each part of this chapter, you’ll learn how to:

  • Part 1: Format and set date variables, and identify text at the beginning and end of a string
  • Part 2: Use indices to parse the contents of a .txt file to transform to Excel
  • Part 3: Use regular expressions to parse the contents of a .txt file to transform to Excel

Follow along with the Text Manipulation Workbook as you watch all three parts to learn more about text manipulation.
 

 
 
 
Ready for the next chapter?

Chapter 4: Spreadsheet Automation