Skip to main content

Posts

Showing posts with the label RPA & Automation

Replace Special Characters from string using Regex in C#

 In this Blog I'll tell you about How to Replace Special Characters Using Regex in C#. To remove a special character from the start of a string in C#, you can use the following code: public static string RemoveSpecialCharacterFromStart(string input) {     // Create a regular expression to match any special character.     Regex regex = new Regex(@"^[^a-zA-Z0-9]");     // Replace the first match with an empty string.     string output = regex.Replace(input, "");     return output; } To use this code, simply pass the string that you want to remove the special character from to the RemoveSpecialCharacterFromStart() method. The method will return a new string with the special character removed. For example, the following code would remove the special character <span class="math-inline">\ from the start of the string `"$$tring"`: string input = "$$$tring"; string output = RemoveSpecialCharacterFromStart(input); Console.WriteLine(out...

Emerging Technologies to Watch in 2023

Emerging Technologies to Watch in 2023 Technology is constantly evolving, and it can be hard to keep up with the latest trends. But some emerging technologies are poised to have a major impact on our lives in the coming year. Here are a few of the most promising technologies to watch in 2023: Artificial intelligence (AI) : AI is already being used in a wide variety of applications, from self-driving cars to medical diagnosis. In 2023, we can expect to see even more widespread adoption of AI, as it becomes more sophisticated and affordable. Virtual reality (VR) and augmented reality (AR) : VR and AR are two technologies that are rapidly gaining popularity. VR immerses users in a completely virtual world, while AR overlays digital information onto the real world. These technologies have the potential to revolutionize the way we interact with computers, games, and even education. Blockchain : Blockchain is a distributed ledger technology that can be used to record trans...

What is UiPath Orchestrator

UiPath Orchestrator is a web-based application that enables the management and monitoring of UiPath Robots and processes. It is a central hub for managing and controlling all your automation tasks, making it an essential tool for enterprise automation. With UiPath Orchestrator, users can easily manage their automation tasks by creating, scheduling, and monitoring processes. The platform allows you to deploy, schedule, and monitor your automation workflows, as well as manage the robots that execute them. The application also provides you with detailed analytics, allowing you to optimize your automation and make data-driven decisions. Designed By: by MANOJ JHA One of the key features of UiPath Orchestrator is the ability to schedule automation processes. With its built-in scheduler, you can set up recurring automation tasks to run at specific times, ensuring that critical processes are executed even when you're not there. Additionally, you can also trigger automation workflo...

What is Abbyy Flexilayout

Abbyy FlexiLayout is a powerful tool for automating the process of document recognition and data extraction. It allows businesses to quickly and accurately extract data from structured and semi-structured documents, such as invoices, bills, and forms. With FlexiLayout, businesses can reduce the time and effort required to manually process documents and improve the accuracy of their data. One of the key features of Abbyy FlexiLayout is its intuitive and user-friendly interface, which makes it easy for users to create and edit document templates. The software includes a wide variety of tools and features that allow users to easily define the layout and structure of their documents, including tools for setting up text, table, and image zones, as well as tools for creating custom recognition rules and scripts. Another important feature of Abbyy FlexiLayout is its ability to automatically recognize and extract data from a wide variety of document types, including invoices, receipts, and for...

Abbyy Vantage detail explanation and how it works

 ABBYY Vantage is a cloud-based software platform for document and data capture. It provides a range of tools for automating the process of extracting information from documents, including OCR (optical character recognition), data extraction, and document classification. Vantage can be used to digitize and process a variety of document types, such as invoices, contracts, and forms, and can be integrated with other business systems and applications. How does Abbyy Vantage work? ABBYY Vantage uses OCR (optical character recognition) technology to recognize and extract text from scanned documents and images. It can also extract structured data, such as names, addresses, and dates, from documents using predefined templates and rules. To use Vantage, you can either upload a document to the platform or connect to it through an API. The platform will then process the document and extract the relevant information, which can be accessed through the Vantage interface or exported to anothe...

Script to automatically convert number to currency

I received a question from a Developer who asked me to help him in a case where he wanted to convert any number into a currency value.  So in this article, we will learn how to displace a number in its currency format. The "C" (or currency) is a format specifier, It is used to convert a number into a string representing a currency amount. Please find the solution below: Refer:  Standard numeric format strings If you have any questions or suggestions please comment.

Table Line Items Iteration using Script in Abbyy Document Definition

 In this blog, I will show you, How we can iterate the table captured in Abbyy Flexicapture, and if we want to update or delete the value then how we can do that.  We can design the layout in Abbyy Flexilayout to capture the table field. To capture the table we can use either the Table element or the repeating group(please check my previous post where I have to explain how to capture the table using the repeating group ). depending on the document and its data layout we can choose any of the methods to capture the table, But iterating through the data is the same for any method's capture data. In Abbyy document definition script there are many programming language options to write your custom script. Following are the list of Programming language available in Custom script: JScript VBScript JScript.Compact C# .Net Visual Basic .Net JScript .Net In this post, I'll use the C# .Net script to show how you can write a custom script. Similarly, you can try another programming langua...

Convert Table item in to List of KeyValuePair string, Decimal in Abbyy Flexicapture

 This post will be helpful in the situation where you want to play around with your extracted table using repeating group elements in Abbyy Flexicapture. In my last post, you can check How to capture table using repeating group element in Abbyy Flexilayout . So after capturing the table in Flexilayout you'd import the export .afl file from Abbyy Flexilaout and import it in the Document definition of Abbyy Flexicapture.  Now when you test run your document definition you'll see the data extracted in the two fields of repeating group field name Table. Those two fields' names will be item description and item amount. Now suppose you want to export your table item only in one field instead of using a repeating group field with multiple line data. So how you'll do that? That is where you can try converting your data into a List of KeyValuePair using C# code and finally export that list into one field. Lets see that in code. So in this code I am assuming you have two table fi...

How to capture table using repeating group element in Abbyy Flexilayout

When we work with Invoice documents or any other documents we often see the table in the document that we need to extract for some reason. It is usually with the invoice document because in the invoice document we have an item table which we often call Line item. This line item shows us the item and the amount for which the invoice is generated. In this post, I’ll share with you how we can extract line items from the document using the character string element inside the repeating group like we extract data in the Table element. So to extract line time from the document first find the header labels. In the table of the document, we can find the header section above the table. Header sections contain static text like serial number, description, quantity, unit price, amount, etc. So we can treat this section as a header and take reference of these static texts for our table. To define this region we can use a static text element and search for any of the header names. See below the image...

UiPath PivotDataTable Activities for Pivot table creation

UiPath has a vast number of external custom-designed activities that developers can use for their RPA projects. In this blog, I am going to talk about an activity that developers can use to create the pivot data table in Excel.  Let's first understand what is a pivot table is and why anyone needs to use this. A PivotTable is a powerful tool to calculate, summarize, and analyze data that lets you see comparisons, patterns, and trends in your data.     - Source NOTE: In this package, it has some limitations where you will only be able to summarize data in a flat data table(Columns and rows). Providing a more clean visualization of the data. You can download this package from the Uipath marketplace where it is available to use for free. This package is developed and published on the Uipath marketplace by  Internal Labs .  Pivot Data table package download link:  Click here to download Now I am going to show you how you can actually use this in your project. Fo...

Setup SMTP Mail with Abbyy Flexicapture Event handler

So after a long break writing back again on Abbyy. What today we are going to see is related to ABBYY scripting for mail on when the document processing stage changes. Recently I was working on a project where a client asks me to add some notification settings in the process of document data extraction when it changes its state from verification to export successfully.  Open your Abbyy project setup station > click on the project that you want to open. After opening the project click on project > project property. In the project property, you will see tabs like "General", "Image Processing", "Recognition", "Verification", "Event handler", ".Net Reference" etc. So in this just click on Event Handler. Event Handler lets you create handlers for events that affect batches, fields, and documents. Event handlers are stored in Batch types and Document Definitions. Following are the types of event handlers which you'll find ...

ABBYY FlexiCapture: Using Label Field Element to find Title and Value

In my previous post, I showed you guys how we can use Static Text Element   and Character String Element    And so now in this post I am going to show you one another important element known as Label Field Element .  Label Field Element is an element by which we can detect Title/Label as well as find the value of the same. It is a compound element which the program uses to search for fields that have names. It includes the following subelements: Static Text : This contains the name of the field. example- invoice number, invoice date, amount, and company name, etc. White Gap : This describes the gap between the name and the value of the fields. Value : This describes the contents of the value field Label Field elements are marked with   in the tree. When Label Field searches for the name of the field, the program will consider the Recognized Words and Recognized Lines object detected by pre-recognition and falling withing the element's search area. So when ...

Start career as RPA Developer using UiPath in 2020

In this blog, you will learn how to become an RPA Developer from scratch. Further, you will learn about the skills and various responsibilities of an RPA Developer. In this blog, I will share my own RPA Developer journey with you guys. Before I start this blog I really recommend you guys to read my last blog where I already have discussed  What is RPA  this blog will help you understand everything about RPA technology.  I hope you read my last blog, So let's start this blog: What is an RPA Developer? RPA Developers are the developers who work on designing, building, and implementing RPA machines. RPA Developer is someone who works with business operations and business analysts to create and optimize the workflow process. They are responsible for designing automation tasks for business use and also for solving automation-based problems.  RPA Developer uses a number of tools and Softwares to automate any tasks. They don't just implement the RPA bots but they ensure tha...

ABBYY FlexiCapture: Finding value of Title/Label using Character String in Abbyy FlexiLayout

     In my previous post, I showed you guys how we can detect the Title/Label from documents using the Static Text element. So now I am going to explain how we can detect the value of title/label from documents.  Check Out => Create SearchElement in Abbyy FlexiLayout to find multiple Static text from documents      In any document finding text, those are static to documents like in Invoice we have Invoice Number, Invoice Date, or header of the table, etc are easy to detect because it is there same in that type of document for any number of page, but when we think of values of title or label then those are not static(same) in all the document. Invoice number, invoice date, and other valuable details are definitely going to be different than each other so in that case, we cant just search those values by using the Static Text element. In that situation, we need another element that is capable of capturing the variable types of items which is not the s...

Abbyy FineReader Engine vs Abbyy FineReader Server

In this blog post, we are going to get some idea about the difference between the Abbyy FineReader Engine and Abbyy FineReader Server. One of my Linkedin connections asked me this question so I thought to write it here on the blog so other people like him can also get some knowledge about this difference.  So let's first understand Abbyy FineReader Engine then we'll talk about FineReader Server. Abbyy FineReader Engine: 1.1- Abbyy FineReader Engine Abbyy FineReader Engine is the Software Development Kit (SDK)  to integrate with multilingual Text recognition and conversion technologies into external applications.   Abbyy FineReader SDK  allows the software developer to create an application that extracts textual information from paper documents, images, or displays. The SDK allows us to convert PDF and Images into a larger number of other digital formats so that the information can be used by humans in IT companies. The FineReader Engine SDK allows to read & recog...

Create SearchElement in Abbyy FlexiLayout to find multiple Static text from documents

               In this post, I am going to explain to you how you can create SearchElement in Abbyy FlexiLayout to detect the various titles of documents, tables, fields, or any text present on all or most of the images in a document. 1.1- FlexiLayout Studio In Abbyy FlexiLayout, "static text" refers to the text that appears in a specific location on a document and does not change from one document to another. For example, the text "invoice number" on an invoice document would be considered static text because it is always in the same location on the document and its content does not change. When creating a FlexiLayout template, you can use the software's tools to identify and define the location of static text on a document. This includes things like setting the text's font, size, and location on the page. Once the static text is defined, the software can use this information to automatically recognize and extract the text from similar docum...

Abbyy FLexicapture Standalone station all application detail explanation

In this post, I am going to cover the Abbyy Flexicapture Standalone station all applications which we get after installation. In my previous post, I have already explained how you can download and install all applications under the Abbyy Flexicapture Standalone station. If you have not seen that yet then visit below link to understand: Download and Install Abbyy Flexicapture Standalone on windows step by step in detail So lets first understand what we get in the package of Abbyy Flexicapture ISO setup. After installing Abbyy on the system we get a list of application as given in image: Now let's understand each application one by one in detail: Abbyy FlexiLayout Studio : FlexiLayout Studio is a software application that allows you to create formalized descriptions of documents with the variable layouts ( you can call it semi-structured documents). In FlexiLayout we define the region of elements that we want to capture for data extraction. FlexiLayout is used for defining the region...

Download and Install Abbyy Flexicapture Standalone on windows step by step in detail

In this post, I will guide you step by step on how you can download and install Abbyy Flexicapture standalone software on the Windows operating system.  Let's understand what is a  Standalone version of Abbyy Flexicapture software: Abbyy FlexiCapture Standalone version is intended for processing documents on one computer it means you have to fix one computer system to use Abbyy Flexicapture Standalone. The program is set up and monitored by an Administrator, while documents are scanned and captured data are verified by the Operator station. Document recognition is carried out automatically. System requirement: CPU                                                  - 2 GHz or More Operating System                        - Windows 7, 8, 10 RAM      ...