Hi Uthaiah, unfortunately I copied and paste and made adjustments to the code just to make it work for my process. At this point in time. I have no experience in editing PDF using iTextSharp. I'm sure the library allow you to create PDF, but I'm not sure about editing PDF.
I keep seeing RPA and AI used interchangeably, but in my opinion, RPA is not AI and vice versa. RPA is not even ML and any integration with ML and AI is not the norm yet. So why is then that articles keep appearing preaching on RPA + AI when it's far from becoming reality at this point in time?
@syed, thank you for sharing your solution. I didn't know that just using the workBookName to refer to an instance of excel would work! That sure saves a lot of time instead of creating multiple versions of the same VBO. Just have to be careful of the uncommon scenario where multiple versions of...
Hi @AhmedTM ,
I've read within BP portal we can expose the objects or process as a web-service which your code can call externally. So the decision making can be made within your code and based on the binary outcome, it could choose between 2 objects/ process that are exposed separately as 2...
I encountered this problem before. When running your process or object that calls the edited MSExcel VBO, you'll need to check and ensure that all the actions that involves the MSExcel comes from the same object. So you cannot use a combination of the original object (for e.g. to create instance...
Hi everyone,
I've managed to finally get some output using itextsharp to read text within a region from PDF. The code inserted in the global code is as follows:
public string ReadtextwithinPDF(string fileName)
{
StringBuilder sb = new StringBuilder();
if (File.Exists(fileName)){...
There's an in-built VBO Utility Strings -> Extract Regex values to extract based on regular expressions. However, it will only extract the first match for the expression. So if you have multiple pattern matches, you'll need to do a code stage to output all the matches onto the collection. You...
Hi @michalides , you'll need to make adjustments and remove ActiveSheet from line 9 and it should work.
newworkbookname = ExecWithTimeout(Timeout, "Save Workbook As",
Function()
Dim wb as Object = GetWorkbook(handle,workbookname)
Dim excel as Object = wb.Application...
@Gokul-Rpa , I've done a code stage to output multiple matches onto a collection. Insert the following global code into a business object and ensure that the language is changed to C#
public DataTable MultipleMatchRegex(string input, string regexpression)
{
DataTable table = new...
From my understanding, Regex does not seem to allow multiple matches using the same expression to be saved, instead it can save the first captured string that matches the expression. So in your case, using the expression
(?<=:\s)([\w-]{9,12})
Should identify 3 matches for the claim numbers...
No problem @imstefano. I think I'm getting the hang of regex. I've been exploring regex and found out that it can even extract the middle of the text if required as well. For e.g., if input text is as follows
Firstname: Zhi
Middlename: N/A
Lastname: Tan
Gender: male
Title: Mr...
Hi @imstefano , I've finally managed to solve the issue of writing multiple fields onto the same collection. Assuming that the input is as follows,
Firstname: Zhi
Middlename: N/A
Lastname: Tan
the following regex code can be used...
I managed to get the result for regex using multiple matches using the example of "ABCD1234XYZ6789" as input and extracting the numbers. To do that, you'll have to assume the text pattern is from left to right, and the regex code is as follows:
(?<myout1>\d+)[A-Z]{3}(?<myout2>\d+)
In this...
@imstefano , correction. I've taken a second look at your solution and it is still not removing the texts after the first name. I've managed to come up with a solution to extract exactly the texts required.
(?<=Firstname\:\s)(?<Firstname>.*)(?=\nMiddlename)
The issue of writing multiple fields...
Hi @imstefano, thank you for the solution. It works as expected. From the syntax, I can further expound on your solution and refine it to be more specific such that I'm pointing to the match immediately after "Firstname: "
(?<=Firstname\:)(?<Firstname>.*)
I tried using 2 actions back to back...
Hi,
I've seen the following post regarding the use of regex to extract text patterns and store onto a collection (http://www.rpaforum.net/threads/how-to-use-the-extract-regex-values-action-of-utility-strings.681/), is there a way to expand on this to extract certain texts after a pattern?
An...
Hi,
I'm using BP version 6.3 and is trying to filter emails using the built-in MS Outlook email VBO to Get Received Items (Basic) and is filtering using email address but I'm getting no output for the Items collection. Using the sender name, there is an output. Have anyone tried this and...
I've found out the issue now. It seems the VBO downloaded from BP portal has hard-coded all the API URL to be from North Europe. So when creating the resource within Azure, it also needs to be from the same region. Alternatively, we can also change this hard-coded URL to be from the same region...
Hi, I've downloaded the Microsoft Intelligent Services from BP portal and followed the steps to create a free account in Microsoft Azure. The subscription keys have been generated and all credentials and environment variables have been created within BP using the subscription key that was...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.