3 Replies Latest reply: Jul 10, 2017 5:51 PM by Wallo Atkinson RSS

    Program to automate file reading from folders

    Shannoy Panankoodan

      Folder Table:

      FolderName

      6709

      6683

      6893

      5567

       

      File Folder Structure would be as follows:


      Source

           FolderName

                ORDER-FolderName.csv

                SALES-FolderName.csv

                PARTS-FolderName.csv

                BUYER-FolderName.csv

                REP-FolderName.csv

       

      Example:

      Source

           6709

                ORDER-6709.csv

                SALES-6709.csv

                PARTS-6709.csv

                BUYER-6709.csv

                REP-6709.csv

          6683

                ORDER-6709.csv

                SALES-6709.csv

                PARTS-6709.csv

                BUYER-6709.csv

                REP-6709.csv

       

      Source\6709\ORDER-6709.csv

      Source\6709\SALES-6709.csv

      Source\6709\PARTS-6709.csv

      Source\6709\BUYER-6709.csv

      Source\6709\REP-6709.csv

       

       

      I have to write a program to go through all Folders listed in the FolderName Field.