Search results

  1. S

    Force retry in Queue

    Hi , Yes it will.
  2. S

    Enter array formula to excel column via Blue Prism

    Hi, Hope this will help you. You can create code stage for it. Input : handle, cellref,Formula Please refer attachment for flow and code. Thanks
  3. S

    Extract Number from string

    Hi, If you are using Utility - Strings::Extract Regex Values without giving "Named Values" Collection (Input ) then use this (?<Lower>\d+) Thanks
  4. S

    Open .msg file + convert to .pdf

    Hi, Check if this works for you. If your .msg file is saved locally. Utility Environment - Start Process can be useful. Application Name - Outlook exe path Argument Name - msg file path this will opens msg file and you can use CTRL+P Thanks
  5. S

    Sql code with single quote issue

    Hi, Try Replace ("O'Connor"," ' ", " ' ' ") Single quotes with two single quotes. Thanks
  6. S

    insert collection into oracle database

    Hi, You can use Data SQL Server from Blue prism or OLEDB. you can find it in Blue Prism Automate\VBO. Thanks
  7. S

    Splitting Collection

    Hi , Copy Rows - Collection Manipulation can help. Thanks
  8. S

    Pull completed Tags

    Hi, I am not sure but you can check QUEUE REPORTS OBJECT- . Thanks
  9. S

    read last row

    If possible try to read complete table in BP Collection as rows are dynamic.
  10. S

    BluePrism- Advance Filter

    Hi , First use find if subject.Column7 contains "ST", if Yes apply filter on row else go next row. PFA
  11. S

    increment the date, month and year

    Hi subhash, You can use Add days Function from calculation stage. PFA. Regards, Shubham
  12. S

    How apply Wrap text option to particular cell using Excel VBO

    Hi, You can create code stage for it. Input : handle, cellref Please refer attachment for flow and code.
  13. S

    How to set the text in a Order

    Hi, You can use Replace function for this. Please refer below expression: Replace([DataItem], NewLine(), "")
  14. S

    SQL Query System.GUID error

    Hi, from same VBO try using Get CSV if you want output as text data item or Get CSV file for CSV file. Regards, Shubham
  15. S

    how to concatenate data items using of "-"

    Hi, Use & instead of '+' in above expression.
  16. S

    Unable to run a process in Control room

    Hi robarik, Please check Blue prism portal : Get Instant answer for this error they have explain reason for this error and method to resolve it.
  17. S

    How to spy cmd using blueprism

    Hi , Did you try launching it using "Utility - Environment::Start Process"?. For attaching to cmd window use window title and child index parameter.
  18. S

    Change file extension

    Hi Check If this Code stage work : Code: PFA: Check And Change Extension Input: File_Path Output: Extension , New _Path Regards, Shubham
  19. S

    Spying mutliple rows in a table.

    Hi manzur, When you are spying the element try to find an attribute which changes its value as number of row changes. Select match type for it as Dynamic and give values to from object.
  20. S

    Using a collection for attachments

    I think you are trying to add data in empty collection, before adding data use Add row action from collection.
Top