Search results

  1. V

    How to run python script

    I have a python script in my desktop, and I need to execute and pass some parameters for the script.. How to achieve this.. How do I approach this.. Please help
  2. V

    How to paste complex excel formula using set cell value

    Hi I need some help on below scenario: I need to paste the following formula to an excel but it not considered as text =RIGHT(A1,LEN(A1)-SEARCH("#",SUBSTITUTE(A1,"|","#",LEN(A1)-LEN(SUBSTITUTE(A1,"|",""))))) What is the escape character in BP?
  3. V

    How to ignore the case in blue prism,

    For example : I am looking for a particular text in an collection, Collection of item gets populated from an application, sometimes I am getting like : 1. Location 2. LOCATION 3. location And also please suggest what is the alternate function for "contains" like in any other language..
  4. V

    Solved Postion of my data in Collection

    Hi, I have a scenario where I wanted to know the position of my data in the collection. For an example : my collection contains 15 records, and I wanted to know to positions of 3 records.. I managed to resolve it with 3 loops breaking with exception as and when I found my match case and jumping...
  5. V

    How to convert NotePad data to a collection

    As an initial approach, I have read the notepad line by line using (Utility file management -> Read Lines from File), then loop over the lines and Mid function to splite and get the required value and stored in an collection. This is working fine.. but wanted to know the best and possible...
  6. V

    Solved segregate the Excel file based on Location

    I want to segregate the excel file based on location, where number of location is not fixed, My Initial approach was 1. Get the excel input as collection and found unique location in an separate collection and 2. Applied filter collection and wrote the output into separate excel files. But...
  7. V

    Solved How to attach collection of files to attachement

    I have used get files from utility file management vbo and got few files into collection, now I want to send those files as an attachment, how to achieve
  8. V

    Solved How to use Filter collection(Utility - collection manipulation)

    Within a loop, I want to use filter collection, for every iteration I need to change the filter criteria, please suggest how to achieve this I have tried all the below combination but its not working : Collection In [ExcelData] Filter "Location = 'India'" : its working fine Collection...
Top