Recent content by mdhazlee

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