Share your ideas for the JMP Scripting Unsession at Discovery Summit by September 17th. We hope to see you there!
Choose Language Hide Translation Bar
Highlighted
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
Highlighted
ms
Super User ms
Super User

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
Highlighted
ms
Super User ms
Super User

Re: if filename contains help

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

 

Contains( files[I], "Values")

View solution in original post

Highlighted
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