6 Replies Latest reply: Feb 5, 2015 10:01 AM by jafreisy Nunez RSS

    loop through to load all files from a folder and its subfolders?

      Hi all,
      This is my folder structure
      MainFolder
             20150102
                            File1a.txt
                            File2ab.txt
                            File3.txt
             20150103
                            File1ab.txt
                            File2a.txt
                            File3ab.txt
                            File4.txt
             20150104
                            File3a.txt
                            File5.txt
                            File6.txt
      I'm trying to use a Loop function but each text file has a different parameter (comma, space, dash, etc. ). I'm also trying to use a wildcard.
      FROM
      [c:\MainFolder\File1*]
      (
      txt, codepage is 1252, no labels, delimiter is '|', msq);
      my loop statement is written similar to this one but fot TXT file instead of CSV.
      how do I combine different parameter, scan folders and subfolder, HELP!!
      Thanks in advance