A2019 - Advanced Fuzzy String Search Bot

This bot can be used to automate the process of evaluating strings of data for similarity

Top Benefits

  • This bot uses the fuzzy match action to compare the values of two strings or files for similarity
  • This action returns a decimal value, which is the match percentage of the two input values in the file/strings

Tasks

  • This bot uses the fuzzy match action to compare the values of two strings or files for similarity
  • This action returns a decimal value which is the match percentage of the two input values in the file/strings

This bot can be used to automate the process of evaluating strings of data for similarity.
For example, you have an automation sequence in which a bot extracts data from invoices, searches a database for the company record, and updates the record with data from the invoice. Use the Fuzzy match action to handle two possible scenarios:

• A mistake occurs at the extraction step where a letter is incorrectly extracted. Instead of Apple, the bot extracts App1e, with a numerical one instead of the letter l.

• There is a small variation between the company name on the invoice and in the database. The invoice contains the company name Apple Inc, but the database has a record for the company name Apple.

Get Bot

Free

Bot Security Program
Level 1
Applications
Business Process
Category
Vendor
Automation Type
Bot
Last Updated
February 16, 2021
First Published
February 13, 2021
Enterprise Version
A2019
ReadMe
ReadMe
Support

See the Bot in Action

Input file 1
Input file 2
Output match percentage range
Output match percentage range
PREV NEXT
Input file 1
Input file 2
Output match percentage range
Output match percentage range

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

  • This bot uses the fuzzy match action to compare the values of two stringsgs or files for similarity
  • This action returns a decimal value which is the match percentage of the two input values in the file/strings