310028_en-US

liliconcom

Open folder using column value

All, 

I am trying to open a folder by searching the characters of its filename based on a column value in my JMP data then concatenate all of the excel file into one file. I managed to create the concatenation part but not the first part, which is to retrieve the folder's filename from a specific JMP column

 

I tried this using this script I saw here as a reference but it doesn't seem to work for me

Retrieve = Open( "C:\*\inputfile.jmp" );
　
x = Column( Retrieve, "Col1" ) << Get Values;
Close(Retrieve,"No Save"); 

TestDir = "C:\test\";
Files = Files In Directory(TestDir); // Returns a list of files in the directory
for(i = 1, i <= N Items(Files), i++,
       If(!IsMissing(Regex(Char(x),Files[i])),
   Open(TestDir ||"\" || Files[i]); 
         ); 
    ); 

 

Data TableOtherScriptingRe: Open folder using column value

Please try Regex Match and Uppercase to make sure they're all in same case format

Retrieve = Open( "C:\*\inputfile.jmp" );
　
x = Column( Retrieve, "Col1" ) << Get Values;
Close(Retrieve,"No Save"); 

TestDir = "C:\test\";
Files = Files In Directory(TestDir); // Returns a list of files in the directory
for(i = 1, i <= N Items(Files), i++,
       If(Regex Match(Uppercase(Char(x)), Uppercase(Files[i]))),
   Open(TestDir ||"\" || Files[i]); 
         ); 
    ); 

Re: Open folder using column valueit shows an error: too many arguments in access or evaluation of 'For' , For/*###*/(i = 1, i <= N Items( Files ), i++, If(
Regex Match( Uppercase( Char( x ) ), Uppercase( Files[i] ) )
), Open( TestDir || "\" || Files[i] ))Re: Open folder using column value

This should work now, extra parentheses was added in the FOR loop

Retrieve = Open( "C:\*\inputfile.jmp" );
　
x = Column( Retrieve, "Col1" ) << Get Values;
Close(Retrieve,"No Save"); 

TestDir = "C:\test\";
Files = Files In Directory(TestDir); // Returns a list of files in the directory
for(i = 1, i <= N Items(Files), i++,
       If(Regex Match(Uppercase(Char(x)), Uppercase(Files[i])),
   Open(TestDir ||"\" || Files[i]); 
         ); 
    );