Search results

  1. S

    Extracting company name from e-mail

    Ah! my bad! i got the parenthesis wrongly placed. This should work- (?<cmpName>(?<=@)[\w.]+)
  2. S

    Extracting company name from e-mail

    Try this... (?<=@)[\w.]+)
  3. S

    Extracting company name from e-mail

    Regex can be used to get the Company name from the email address. Here is the regex- (?<=@)[^.]+(?=\.) Check for the threads on how to use the Regex and replace the regex pattern with the above expression. Post back how it goes!
  4. S

    How to Integrate HP ALM with Blue Prsim

    The other way is to use APIs to create Jira issue using HTTP VBO.
  5. S

    How to insert excel spreadsheet in Word document

    A begin with... you can approach the problem statement by recording a Word Macro and customize it to BP - Sub Macro1() Selection.InlineShapes.AddOLEObject ClassType:="Excel.Sheet.12", FileName _ :="C:\Test.xlsx", LinkToFile _ :=False, DisplayAsIcon:=True, IconFileName:= _...
  6. S

    Data in the data Item search

    You can rely on regex. Give an example string for precise answer.
  7. S

    Removing space's from a string of text with a paragraph

    You can try this Replace([Details Read - New], NewLine(), "") , this will replace the newline
  8. S

    How to Manipulate Date

    Ah! missed it completely, you should have asked question in a straight way. This expression should help- FormatDate(AddDays(Today(), 6), "dd-MMM-yyyy")
  9. S

    How to Manipulate Date

    Try expression FormatDate(Today(), "dd-MMM-yyyy")
  10. S

    How to use wildcard or like command in decision stage

    Try expression Instr([Attachments], ".pdf"). InStr() returns the position of the .pdf it finds in [Attachments] data item, else it returns 0.
  11. S

    Filter collection

    If the DataItem1 is text type add single quotes, I missed that point. Like below- "Name ='"&[DataItem1]&"' AND Age="&[DataItem2]&"
  12. S

    How to insert data in sql server by using code stage in Blue Prism, Can anyone help me in this please?

    Looking at the code snippet, you also have to pass Server and Database names as inputs. Have you? Also, change the input parameter name, InputData to DataCollection. @naveedraza can you share more details of your code usage?
  13. S

    Extract regex value - Lower and Upper Results

    Good to know!
  14. S

    Filter collection

    While applying filter, you have to use the field names and not Collection name dot field name. If Name and Age are the fields of collection, you can use "Name ="&[DataItem1]&"AND Age="&[DataItem2]&". If you have the values to compare Name and Age in data items DataItem1 and DataItem2...
  15. S

    How to send huge data in sql faster

    Sure, that would help the community! The suggestion i shared using OPENROWSET is a single step to import data from excel file to SQL Server, however would need configurations. Refer to the link.
  16. S

    How to insert data in sql server by using code stage in Blue Prism, Can anyone help me in this please?

    @naveedraza has posted a reference code using SQLBULKCOPY, take a look at this post- https://www.rpaforum.net/threads/how-to-send-huge-data-in-sql-faster.10486/post-20779
  17. S

    String Functions - Blue Prism

    If you highlight a function under the Function section of Calc stage, towards right side, an example of usage is shown. For Date Functions, use Help documentation.
  18. S

    How to send huge data in sql faster

    @naveedraza Reading the problem statement, @Pallavivalunj is looking to insert data directly in to SQL Server from Excel as there is memory issue while copying such huge data of 80k to 1lakh records from Excel into Collection. I am assuming, your solution holds well when trying to write...
  19. S

    Extract regex value - Lower and Upper Results

    The Field Names of the 'Named Values' collection should be 'Name' and 'Value'. You have named fields as 'ProdCode' and 'Value'. Add a row to the 'Named Value' collection and put 'ProdCode' in to 'Name' column and leave 'Value' field blank. On successful execution 'Value' will be updated in the...
Top