Search results

  1. S

    Solved Comparing two Collections and and saving unique values.

    The code part is not to be done in Global Code area. Instead create a new page, and inside that page add a code stage where the above code should reside. The collection Data Items have to be created in the same page and should be passed as Inputs & Outputs to the code stage.
  2. S

    Find and remove matching values in collections

    I have answered this question here :
  3. S

    Expose Blue prism Process as REST Service

    Blue Prism does not support exposing process/object as RESTful services. You can achieve the same by having a middle layer of another API gateway which converts SOAP->REST & REST->SOAP.
  4. S

    Microsoft Word Styles for Heading Numbering across Doclets

    This requirement is not something that comes pre-package in Word VBO. You will have to create a custom action, to traverse all paragraphs in the active document. If a heading is found, set = "Heading1" and so on Going through...
  5. S

    Download File via HTTP

    The API clearly requires a Body for you to be able to directly download the file. Without relevant details like address, body and header information, there is only so much one can help you with. Easier way out is to : Paste the contents of the text data item in the file.
  6. S

    Runtime showing as Idle but Not Connected

    Pretty sure that the Resource PC is not started on the target VM where you want the process to execute. When you open BP client, it launches a Resource PC by default. Without opening BP client, you need to explicitly start the Resource PC. Try this : On the VM, without opening BP client...
  7. S

    how to read specific text in word file using regular expression dynamically ?

    Assuming the dates will be valid, use this regex : (January|February|March|April|May|June|July|August|September|October|November|December)\s+\d{1,2},\d{4}
  8. S

    Issues Reading XML

    I couldn't find a single xml file containing <CPV MAIN>12345678</CPV MAIN>. So, with limited information, here's what you can try: Use Regex to extract the specific value : (?<=<CPV MAIN>).*(?=<\/CPV MAIN>) which will return 12345678
  9. S

    Issues Reading XML

    Try to explain the question again. Are you looking to get a collection of all file names, inside the zip ? Are you looking to get a collection of each file's entire contents, inside the zip ? Are you looking to get a collection with only specific XML data extracted ?
  10. S

    Solved Comparing two Collections and and saving unique values.

    That would be an incorrect solution, besides the fact that it would take more time to execute. Merging & removing duplicates will fetch all unique records from both collections. OP only wants unique values present in 1st collection that are not present in 2nd collection.
  11. S

    Solved Comparing two Collections and and saving unique values.

    Make sure to add below 3 Namespaces in Code Options Section : System.Data System.Collections.Generic System.Linq Make sure to add below 2 External References in Code Options Section : System.Core.dll System.Data.DataSetExtensions.dll Create a code stage with Collection_1 & Collection_2 as...
  12. S

    Expression to select first day of month

  13. S

    Replace String

    My bad. Here is the correct syntax : Right([TEXT],3)&"-"&Left([TEXT],InStr([TEXT],"-")-1)
  14. S

    Replace String

    [TEXT] is the data item having values like 26243-Jan, 99-Feb etc Step 1: Use this in calculation stage Right([TEXT],3)&"-"&Left([TEXT],"-")-1) This will convert 26243-Jan to Jan-26343 Store this back in [TEXT] Step 2: Use a long REPLACE statement to replace Jan=1,Feb=2,March=3 & so on...
  15. S

    Read Value from Web Page

    Why do you need a code stage to read the data? A simple element in application modeller with read stage can do the job.
  16. S

    OLE DB Filter Excel Data

    Everything appears fine. I even tried running the query mentioned in the post and it was successful. Excel File : Query : "SELECT * FROM [Folha1$] WHERE [F1] ='#DET;2021;01;0498874;OPAO;0000645282,00;000987;0087,09;000000000,00;;'" Output :
  17. S

    Separate value from column

    Use Action Split Text in Utility-Strings VBO : Text to Split : [Collection.rates] Split Char : ","
  18. S

    Global Sendkeys Password

    Try to send send CTRL+V to password field. Have the password stored in the clipboard via set clipboard action.
  19. S

    Global Sendkeys Password

    Please verify if you are using Global Send Key Events instead of Global Send Keys