Choose Language Hide Translation Bar
Highlighted
rverma
Level II

How to walk a directory with many sub-folders to fetch specific files?

Hello,

 

I have a folder/directory with many sub folders. In each of the subfolder there are bunch of csv files. Each csv file has a unique ID in the filename. My question is that if I have a list of IDs then how can I traverse the directory to fetch those specific csv files and concatenate them in a jmp table? Is there a way to do it with a script (JSL)? I will appreciate any guidance. CSV file name is similar to "Y123456_File_27A7Z123456.csv". String after File_ is the unique id.

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
txnelson
Super User

Re: How to walk a directory with many sub-folders to fetch specific files?

The Files in Directory() function has a recursive option that returns the full path to each of the files found.

 

See

     Help=>Scripting Index=>Files in Directory

Jim

View solution in original post

3 REPLIES 3
Highlighted
txnelson
Super User

Re: How to walk a directory with many sub-folders to fetch specific files?

The Files in Directory() function has a recursive option that returns the full path to each of the files found.

 

See

     Help=>Scripting Index=>Files in Directory

Jim

View solution in original post

Highlighted
rverma
Level II

Re: How to walk a directory with many sub-folders to fetch specific files?

Thank you. I was able to achieve what I wanted by saving all filenames in the directory into a list.

 

filelist=Files In Directory( path1, recursive);


Then I created another list of the unique IDs.

 

unitIDlist = {"AA", "AB","AC"};


Finally I used Nested For loop to find the files that contains unique IDs in the filename and open and concatenate them to the first file.

Highlighted
Craige_Hales
Staff (Retired)

Re: How to walk a directory with many sub-folders to fetch specific files?

also take a look at multiple file import. It may be exactly what you need.

Craige
Article Labels

    There are no labels assigned to this post.