Search results

  1. S

    Data in the data Item search

    You can rely on regex. Give an example string for precise answer.
  2. 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
  3. 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")
  4. S

    How to Manipulate Date

    Try expression FormatDate(Today(), "dd-MMM-yyyy")
  5. 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.
  6. S

    Filter collection

    If the DataItem1 is text type add single quotes, I missed that point. Like below- "Name ='"&[DataItem1]&"' AND Age="&[DataItem2]&"
  7. 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?
  8. S

    Extract regex value - Lower and Upper Results

    Good to know!
  9. 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...
  10. 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.
  11. 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
  12. 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.
  13. 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...
  14. 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...
  15. S

    Python In Blue Prism?

    I never tried it, but following the link i posted earlier, it is C#. Give a shot at it and post your comments, it helps community.
  16. S

    How to send huge data in sql faster

    @naveedraza I am supposing the code writes collection data to sql server, isnt it?
  17. S

    Internal : Unable to convert supplied value to a Number : Unable to cast value '' to a number data item

    Check if you have blank values in excel file. One of the reasons for the exception is when there is an attempt to convert text which is blank to number. "Unable to convert supplied value to a Number : Unable to cast value ' ' to a number data item"
  18. S

    String Functions - Blue Prism

    In the Calc stage, under Functions section, expand Text to find all the string functions. The code details of these functions are not exposed, i believe.
  19. S

    How to send huge data in sql faster

    Using T-SQL OPENROWSET, you can perform the data move from excel to SQL server. Check this link for more details- https://docs.microsoft.com/en-us/sql/t-sql/functions/openrowset-transact-sql?view=sql-server-2017
Top