Search results

  1. A

    Dropping File Extension from File Name

    Hi, Part of my process involves me grabbing file data from a folder and adding it to a collection. I'd like to append the collection by adding an additional column to the collection that contains the file name without the extension. For example, row one would contain just "02" instead of...
  2. A

    Alternative to Nested Loop

    Thanks for the reply! Yes, this works and might be the option I go with. The problem is that C2 (Get all Files) will always have more rows than C1. At the end of the day, it will be much faster than what I originally had.
  3. A

    Alternative to Nested Loop

    Correct. To create collection C2, I'm using the following action Business Object: Utility - File Management, Action: Get Files. The collection that's created contains the file path. The issue I'm experiencing with Business Object Utility - Collection Manipulation, Action Collection Contains...
  4. A

    Alternative to Nested Loop

    Thanks for the suggestion. I tried using it but it doesn't work. The match is found, but there is no way to output the file path to prepare to move the file.
  5. A

    Alternative to Nested Loop

    Understood. That's essentially what I'm doing already. When you say collection comparison, do you mean to use a loop?
  6. A

    Alternative to Nested Loop

    Hi, I have a process where I add an excel spreadsheet to a collection (C1). The spreadsheet contains a list of file names. I then create another collection (C2) that contains all file data from a specific directory. Then, I have a nested loop that loops through both collections on the file...
Top