< All Bots

Extract Number

Bot Extract only Number from mixed data string and numeric and give output in Text and Excel file. So person can get good split data as per their requirement.

Top Benefits

  • Extract Number from Mixed data.
  • You can Extract Employee Id or Amount if its comes in a column with string.
  • its help to get meaning full data for your further use.

Tasks

  • Read Data from Excel file.
  • Extract Number in other column
  • Create text and excel file and give output
  • It work with script file that do the whole work.

Bot Extract only number from mixed data that contains Text and numbers and give output in Text file and Excel file. So we can have good split data as per requirement. Some time we get Employee ID and their id in a single column and we need to split ID that require for further work then this is the perfect bot that work very fast as its work with script file.

Get Bot

Free

Applications
Business Process
Category
Security
Passed third-party anti-virus scan conducted by Automation Anywhere.
Downloads
18
Vendor
Automation Type
Bot
Last Updated
November 15, 2019
First Published
November 12, 2019
Enterprise Version
11.x
Community Version
11.3.1
ReadMe
ReadMe
Support

See the Bot in Action

Above Image refers to the input file of the raw data.
Above output image for the number that extracted.
Above Image is the code of the entire process.
PREV NEXT
Above Image refers to the input file of the raw data.
Above output image for the number that extracted.
Above Image is the code of the entire process.

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

  • Inuptfile.xlsx