Extract Numbers

Bot extracts just the numbers from mixed data containing strings and numeric values.

Top Benefits

  • Extracts Numeric values from mixed data.
  • You can Extract Employee Id or Amount if its comes in a column along with string

Tasks

  • Read Data from Excel file.
  • Extract Numbers in other column

Bot extract just the numbers from mixed data that contains both text and numbers and gives output in Text file and Excel file format.

Use Case:  In HR department, sometimes Employee ID and their Id comes in a single column and it's required to split the ID that's required for further processing. This Bot works very fast as it works with a script file.

Get Bot

Free

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

See the Bot in Action

Input file
Output
Bot Code
PREV NEXT
Input file
Output
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