cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Submit your abstract to the call for content for Discovery Summit Americas by April 23. Selected abstracts will be presented at Discovery Summit, Oct. 21- 24.
Choose Language Hide Translation Bar
AlexS
Level III

if filename contains help

Hello

 

I can't seem to open jmp data tables in a folder in which filename  contain "Values"

the log isn't telling me anything helpful either ...

i am sure its something obvious but i can't see the error!

Names Default to Here( 1 );



Set Default Directory( "C:\Users\" );

files = Files In Directory( "C:\Users\" );

For( i = 1, i <= N Items( files ), i++,

          If( contains( "Values",files[i]),

                    Open( files[i] );

                    

          )

);
Alex is the name, Power BI/ SQL /JMP is my game
1 ACCEPTED SOLUTION

Accepted Solutions
ms
Super User (Alumni) ms
Super User (Alumni)

Re: if filename contains help

Try reversing the order of the arguments in Contain().

 

Contains( files[I], "Values")

View solution in original post

2 REPLIES 2
ms
Super User (Alumni) ms
Super User (Alumni)

Re: if filename contains help

Try reversing the order of the arguments in Contain().

 

Contains( files[I], "Values")
AlexS
Level III

Re: if filename contains help

could've sworn i tried that.....as if by magic this solves my issue thanks!

Sometimes you just need another pair of eyes!

Alex is the name, Power BI/ SQL /JMP is my game