Recent content by RReed

  1. R

    Attaching to Excel fails

    Hi Daenerys, Just a few questions regarding your process. Is there a reason as to why you are using an action to click into Excel? Blue Prism should have a Excel VBO object provided along as part of its software which should allow you to do what you are looking for. There shouldn't be a need...
  2. R

    Duplicate Mail Issue

    Not sure if this is the same issue you are facing but it could be due to the version of Microsoft Outlook being used. I saw on the BP forums that Microsoft 360 outlook may cause duplicate emails being sent out due to drafts being saved...
  3. R

    Process a collection - get file name

    When you are dealing with Collections, you can think of each field as a separate data item within the collection. So if you are trying to grab a specific field from the 'Get Files' Collection, you can set it as this: [Collection Name.Field] Collection Name would be based on what you had named...
  4. R

    Convert month name to month number eg: December - 12

    There's a few ways to go about it but most commonly used would be using the FormatDate logic within Blueprism to convert. One potential way would be to do this: FormatDate([Date],"dd")&"."&FormatDate([Date],"MM")&"."&FormatDate([Date],"yyyy")
  5. R

    Solved Comparing two Collections and providing unique value output - Narrowing down based on 1 field

    Hi Sahil, that was actually what we tried using first but it didn't turn out too well mainly because we only wish to have the unique values only while the remove duplicate will still give us one of those values back. For example here is what would be how the collection would look like...
  6. R

    Solved Comparing two Collections and providing unique value output - Narrowing down based on 1 field

    Hi all, I know this was somewhat answered via https://www.rpaforum.net/threads/comparing-two-collections-and-and-saving-unique-values.14717/ But I would like to see if there is a way to further narrow down a comparison using code stage for Blue Prism. The given code is the following...
  7. R

    Need help with Regex

    Hi Pete, Try testing out using this Regex expression: \b(\w+(?:\s*\w*))\s+\1\b
  8. R

    Solved Soft Terminate MS Edge - Restore Page Issue

    I used the <{CTRL}{W}>{CTRL} send keys to help with closing the browser. But this is only effective if your application is using just one tab on the browser. There was another suggestion mentioned on the Blue Prism forum but I found that the send key was enough for what I was trying to do. For...
  9. R

    Solved Soft Terminate MS Edge - Restore Page Issue

    Closing thread, found solution to this by using global send key function.
  10. R

    Solved Soft Terminate MS Edge - Restore Page Issue

    @RsBhargav Unfortunately, I am only able to try the first suggested step which didn't work. The other steps need admin access which I do not have.
  11. R

    Solved Soft Terminate MS Edge - Restore Page Issue

    Hi all, Is there a way within Blue Prism for us to soft terminate MS Edge application which doesn't trigger the Restore Page popup to occur? In our current state, Blue Prism is able to use the terminate action to close the MS Edge application. But once we try to launch a new application browser...
  12. R

    Solved Collection Manipulation and Writing Specific Data into collection

    Thank you eric! Implemented how you did it and it works like a charm!
  13. R

    Solved Collection Manipulation and Writing Specific Data into collection

    Hi eric, It's a bit of both actually. I do have an Excel file given to me to work as an input file but was advised I should try and manipulate my data within Blueprism instead of within the excel. As such, the screenshots provided were more to to just illustrate how the layout would be. I'll...
  14. R

    Solved Collection Manipulation and Writing Specific Data into collection

    Hi all, I am trying to figure out if something of the following is possible within Blueprism: I have a set of data which I have stored into my collection that I am trying to manipulate and store into a 'master' collection. What I am trying to do is the following: From the collection listed...
Top