Deleting and moving JMP data files on disk from JSL

[#1]

There's an exceptionally helpful thread on this forum at https://communities.sas.com/message/32475#32475 which shows how to use DLL files to delete or move data files from within JSL, but the script appears to be specific to Windows.  I'd like to assemble something that would work equally well on both Windows and Macs.  Does anyone know if that can be done please - and if so, how?

[#2 · Accepted solution]

Hi,

If you're using jmp 10.0.1, some new functions are available

http://support.sas.com/demosdownloads/000981/JMP_1001_release_notes.pdf

JSL File and Directory commands are available, including :

File Exists( path )

Directory Exists( path )

Copy Directory( from, to, {1/*recursive*/} )

Copy File( from, to )

Move Directory( from, to )

Move File( from, to )

Rename Directory( old, new )

Rename File( old, new )

Delete Directory( path )

Delete File( path )

Create Directory( path )

Last Modification Date( path )

Creation Date( path )

[#3]

Even better than I'd hoped for.  Many thanks!

[#4]

All, Copy File() works in JMP 9.0.3 (or at least for me).  Very nice.  dj

[#5]

Can some one share a move file jsl by search the key words in file name?

Thank you

[#6]

This is very old post and some functions might have changed or there might be new ones.

1. Use Files In Directory() (or some other way) to get a list of file names
2. Use appropriate character functions on those items by using a loop (For Each, Filter Each if you have JMP16+, if not use For loop) to filter down the list
   1. Contains(), Starts With() , Ends With() . And for more complicated comparisons you can for example use IsMissing() with Regex()
3. Perform action on the filtered list