Search results

  1. M

    Copy text within bounding coordinates in PDF

    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.
  2. M

    Copy text within bounding coordinates in PDF

    @Uthaiah , that's right. I used the following External references and namespace imports.
  3. M

    Everything you need to know about RPA

    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?
  4. M

    Error in Executing VB Script

    @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...
  5. M

    ML integration with Blue Prism

    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...
  6. M

    Error in Executing VB Script

    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...
  7. M

    Copy text within bounding coordinates in PDF

    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)){...
  8. M

    How do I split a text value by the TAB Char

    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...
  9. M

    How to Convert Excel to PDF using Blueprism

    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...
  10. M

    Solved How to use the 'Extract Regex Values' action of Utility - Strings

    @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...
  11. M

    Solved How to use the 'Extract Regex Values' action of Utility - Strings

    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...
  12. M

    Solved Using Extract Regex values action to get text after pattern

    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...
  13. M

    Solved Using Extract Regex values action to get text after pattern

    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...
  14. M

    Solved How to use the 'Extract Regex Values' action of Utility - Strings

    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...
  15. M

    Solved Using Extract Regex values action to get text after pattern

    @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...
  16. M

    Solved Using Extract Regex values action to get text after pattern

    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...
  17. M

    Solved Using Extract Regex values action to get text after pattern

    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...
  18. M

    No output using MS Outlook Email VBO

    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...
  19. M

    Solved Microsoft Cognitive - Computer Vision not working

    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...
  20. M

    Solved Microsoft Cognitive - Computer Vision not working

    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...
Top