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...
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();
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",
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
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
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,
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:
@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.
The issue of writing multiple fields...