Extract Text

Bot extracts just the text from mixed data that contains text and numbers.

Top Benefits

  • Get data as per our requirement and we can work text only.
  • We can get the output in 2 formats, Text file and Excel file as per the requirements

Tasks

  • Extracting text from mixed data through VB scripting

Bot extracts the text from mixed data that contains text and numbers and gives output in Text file and Excel file. So we can have good split data as per requirements. Use cases: Sometimes we get Employee name and their id in a single column and we need to split names or any text that's required for further processing, then this is the perfect Bot that works very fast as its works with a script file.

Get Bot

Free

Bot Security Program
Level 1
Applications
Business Process
Category
Downloads
63
Vendor
Automation Type
Bot
Last Updated
December 14, 2020
First Published
November 10, 2019
Platform
11.x
Community Version
11.3.1
ReadMe
ReadMe
Support

See the Bot in Action

Input file with mixed data including both text and numbers
Output file in text file containing just the alphabets
Bot Code
PREV NEXT
Input file with mixed data including both text and numbers
Output file in text file containing just the alphabets
Bot Code

Setup Process

Install

Download the Bot and follow the instructions to install it in your AAE Control Room.

Configure

Open the Bot to configure your username and other settings the Bot will need (see the Installation Guide or ReadMe for details.)

Run

That's it - now the Bot is ready to get going!

Requirements and Inputs

  • Input file in Excel format