Search results

  1. B

    Open Specific File in a Folder (Loop through multiple folders)

    In Automation Anywhere, there is a specific loop activity for looping through folders within a folder. There is also a loop activity for looping through each file within a folder. You will need to create a nested loop to go through all of the files within all of the folders. Within the inner...
  2. B

    New Line character as a split delimiter.

    You can type "[ENTER]" to specify newlines as the delimiter.
  3. B

    Find Minimum and Maximum Values from a CSV

    In the same loop you can: Sum all of the values Count all of the values Then outside of the loop divide the sum by the count.
  4. B

    Find Minimum and Maximum Values from a CSV

    You may need to use a loop to iterate over each value to find the minimum and maximum values.
  5. B

    writing vlookup using Excel commands

    The Set Cell activity allows you to insert formulas. Just enter what you would normally enter in Excel.
  6. B

    PDF to EXCEL Automation PO

    It's possible to extract the information you need by using the PDF Extract Text activity, ensuring that the "Structured text" option is selected, and looping through each line of the resulting text file. You can use regular expressions with the various String Operations to get the information...
  7. B

    Copy files from VDI Machine

    You may have to setup a shared folder to accomplish this.
  8. B

    Finding field in email

    You can choose the Plain Text option in the Message Format field in the Email Automation activity.
  9. B

    Outlook confinguration

    I've been using the "Perform various outlook operations" MetaBot from the Bot Store: https://botstore.automationanywhere.com/bot/perform-various-email-operations/
Top