Search results

  1. L

    Filter Collection

    Hello, can you please help me with the below example. Mail Subject : [hi][hell0]**-******_chars **-****** (This is fixed 9 digit number including -) How I should filter a collection without having 9 digit number.
  2. L

    Parent and Child Object

    Hi, Please someone explain on Parent Child relationship queue. How a single item can be added to Parent Queue which have data of all child items. This is some what confusing.
  3. L

    Collection filter by Date

    Hi Gil.Silva, I have an excel where the column is in text format having dates in mm/dd/yyyy format and in the same column there is some text coming in. So, I wanted to write a query using oledb to fetch that column having dates older than 9 months. Could you please help me on this.
  4. L

    Solved Remove row values dynamically

    Hi, Can you please tell me how to achieve removing a row from collection without using loop stage. Example : In collection1, I have 500 rows and in collection2, 11 rows. So, matching rows has to delete from collection1. So, I will loop Collection2 and using filter collection action in...
  5. L

    Formatting the cell value in excel with blue prism

    Using MS Excel VBO Utility, I want to format the entire column to date from text. How can I achieve this? Also the date format should be mm/dd/yyyy. Could anyone please help?
  6. L

    how to Update sql table from collection data in one go?

    Okay, thank you Sahil for your reply.
  7. L

    how to Update sql table from collection data in one go?

    Hi, Could you please provide the syntax on how to copy the whole collection data to excel sheet in one go. I am able to get one row at a time to excel sheet not the whole collection data. Please suggest.
  8. L

    Copy data from collection to excel

    Could anyone please help while using oledb how to copy whole collection data in one go to excel sheet other than using MS Excel VBO
  9. L

    Unable to open Repairable Excel File with Blue Prism

    I am downloading the .xls file from web page which will be downloaded in downloads folder. I want to save the file with an extension .xlsx. Is there any possibility in blueprism to get it worked? I have tried to use save workbook as..but it is just saving the file in different location not...
Top