Search results

  1. S

    adda number to text?

    A code stage works best but if you need one without creating a new code, then Step1 Step 2 Concatenate "AB" to the output of Step1
  2. S

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

    Gotcha! Here is the code. Hope it helps: Collection_3 = Collection_1.Rows.OfType(Of DataRow)().Where(Function(a) Collection_1.Rows.OfType(Of DataRow)().[Select](Function(k) Convert.ToString(k("Street"))).Except(Collection_2.Rows.OfType(Of DataRow)().[Select](Function(k)...
  3. S

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

    If you are seeking unique values from both the collections combined, wouldn't merging the collection and removing duplicates based on "Street" column serve the purpose ?
  4. S

    Refresh Pivot

    Download the update version of Excel-VBO having Pivot related actions - https://digitalexchange.blueprism.com/dx/entry/9648/solution/ms-excel-vbo---extended or you can create a custom code stage with something like this : ws.PivotTables(PivotTableName).SourceData = "pivotsheet!A1:C15000"
  5. S

    How to use data item as cell reference for excel in Blueprism

    Considering the collection field is "row-id" and collection is "Col", try this : "A"&[Col.row-id]&":F"&[Col.row-id]
  6. S

    Not able to delete folder through Blue Prism

    Have you checked the folder permissions on the account that is currently logged in to Blueprism ? Nevertheless, utilize command line to del the folder. Use this command : rmdir /s/q "FULL_FOLDER_PATH" You can use "Run process"/"Start process" action in one of the Utilities VBO
  7. S

    Special Characters from Collection to Excel

    Its an old issue that was packaged with Blueprism. Basically the shipped Excel VBO from an older version fetches the data from clipboard in Text format instead of UnicodeText Open the Global code of Excel VBO and look for line : Clipboard.GetDataObject().GetData(DataFormats.Text, True) and...
  8. S

    How can an Excel handle be shared?

    Why not directly use the attach action present in the Excel VBO ?
  9. S

    Microsoft Word - Save As Object

    There are a couple of issues with what you are trying to achieve: 1) The ExecWithTimeout is a private Function/Sub which is a part of Excel VBO and not Word VBO, which is why you are getting the error 2) newname = doc.name will generate an error in a lambda expression, as newname is the output...
  10. S

    Pick the last 5 days date. excluding weekends and public holidays

    First, create a new calendar with all the holidays listed. Use Internal VBO : Calendar and Action : Get Working Days in Range
  11. S

    Solved Setting Multi-Line text and storing data item variable within another data item

    You can have a skeleton stored in a Data Item, lets call it [Text_1]. Text_1 Initial value should be: STOP STOP CMD PREP NO Dynamic Value Here END TRANSTYPE,B,S SETTDATE GO GO Use a calculation stage to replace 'Dynamic Value Here' with whatever value is arriving dynamically...
  12. S

    Forwarding/Deleting an email with Agilify

    The Message-ID that you see in the Outlook client under File>properties>Internet headers IS NOT THE SAME as the actual message Id of the respective email. I hope you are using the message id returned from one of the action of the VBO. If not, look for an action which outputs the message id of...
  13. S

    How to use Filter Expression in MS Outlook VBO(Advanced) in Blueprism

    You can continue to use the Get Received Items (Basic) Action for this. In the Subject Input, use "%Plant Name:%" For Get Received Items (Advanced), try : "@SQL=urn:schemas:httpmail:subject LIKE '%Plant Name:%'"
  14. S

    Update multiple values in Oracle (SQL) in one shot

    Haven't tried it myself, but here are some references that maybe helpful : https://stackoverflow.com/questions/12464616/oracle-bulk-updates-using-odp-net https://www.rpaforum.net/threads/how-to-send-huge-data-in-sql-faster.10486/#post-20779
  15. S

    Filter the collection with Date range

    Filter : "[Date] > '10/7/2021' AND [Date] < '12/7/2021'" (Replace the random dates specific to your requirements)
  16. S

    finding a row in a collection containing a specific value

    I couldn't understand the question clearly. Refer this : https://www.rpaforum.net/threads/comparing-two-collections-and-and-saving-unique-values.14717/#post-31525 Is this something you are after ? If not, please post more screenshots to explain it better.
  17. S

    String manipulation

    Left([Data Item],8)&"00"
  18. S

    selecting items in sap field selection?

    Here are 3 ways : 1) (Recommended) Create a custom code stage. SAP provides "Script Recording & Playback" feature which you can leverage to sneak peek the code and customize it to suit your needs. 2) Look for a keyboard shortcut and use that in send keys. Refer Here for Keyboard Shorcuts 3) Try...
  19. S

    Dropdown Selection Not Recognized When Using "Select Item"

    Were you able to find a resolution to this ? For such scenarios, where the dropdown selection isn't registered by the webpage, try to send "TAB" key after selecting the item. Select Item(Browser mode) > Focus Dropdown(Win/AA/UIA) > Send Tab Key (GSK/GSKE) It has worked for me in past with...
  20. S

    Firefox is getting crashed frequently at launch step itself

    It does seem like environment specific problem, which are hard to troubleshoot. Try to run the process on a different machine and evaluate. If it still fails, reach out to BP support
Top