How to walk a directory with many sub-folders to fetch specific files?
Feb 27, 2020 3:07 PM(1340 views)
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.