Recent content by ShubhamJangam

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