Recent content by sahil_raina_91

  1. S

    Set 2 letter words to uppercase in a data item?

    In a decision stage use expression - Len(Replace(Replace ([Data Item],"(",""),")","")) = 2. Connect YES with calculation stage - Upper(Replace(Replace ([Data Item],"(",""),")",""))
  2. S

    Check for brackets in a data item and update first letter to uppercase?

    1) [Name] is the original data item Trim(Left([Name],InStr([Name],"(")-1))&" "&Replace(Mid([Name],InStr([Name],"("),Len([Name]))," ","") 2) [New Name] is the data item storing result from Step 1 Upper(Left([New Name],1))&Mid([New Name],2,InStr([New Name],"(")-1)&Upper(Mid([New Name],InStr([New...
  3. S

    Check for brackets in a data item and update first letter to uppercase?

    Will the value of data item always begin with ( and end with ) ? If not, please list all possible variations
  4. S

    How to remove the last character of a string

    That should not be the case. If the result of the action before this is "John-Joe-" (Let's say this is stored in Text Data Item called : Name) Then, Left([Name],Len([Name])-1) should result in "John-Joe" and NOT "john-joe"
  5. S

    BP crashes when trying to use LoadBinaryFile function on PDFs size greater than 50 MB

    You should definitely get in touch with Blue Prism official support / community forums for this questions. As far as I know, they haven't mention any size limit for LoadBinaryFile function.
  6. S

    Connect BluePrism to Database

    The error is because of " character. [File Name] data item current value should be without double quotes in front and back.
  7. S

    How to remove the last character of a string

    Use the expression : Left([Data Item],Len([Data Item])-1)
  8. S

    Connect BluePrism to Database

    You need to give complete file path and not just the file name as input. If you still can't figure out, please show us the value of [File Name] data item
  9. S

    Connect BluePrism to Database

    1. Read the collection from excel 2. Remove duplicates from collection 2. Run a loop on the collection 3. Inside the loop, call Action : Execute with statement : "Insert into TABLENAME values ('"&[1]&"','"&[2]&"','"&[3]&"')" Replace [1] = [collection.Tipo fattura] [2] = [collection.Tipo...
  10. S

    Connect BluePrism to Database

    In VBO : Utility - Data - SQL Server, use Action : Set Connection. Enter the details from SQLServerExpress into above 4 fields, to connect to the specific Database. Next use Action : Execute to run your queries.
  11. S

    Multiple process on same machine

    You can have multiple resource PCs on the same VM/machine. Start them using the CLI and mention different ports for each one (default port = 8181). In the Blue Prism executable folder, use the command "automate.exe /user {username} {password} /resourcepc /public /port 8191", "automate.exe...
  12. S

    Properties in Credentials

    I am unaware of a property called USAGE. Any source from where you picked this up ? Very slim chance it is introduced in the latest versions.
  13. S

    Properties in Credentials

    Additional properties are nothing but {key:value} pairs that can be stored alongside the credentials. You can get a property value with Action : Get Property of VBO : Credentials You can store any {key:value} pairs in properties. Example : {name:Bala} , {date:1/8/2021}
  14. S

    Solved Using Regex to capture variable

    If you are validating either numbers or uppercase NIL = (\d+.\d+)|(NIL)
Top