topic Re: Deleting and moving JMP data files on disk from JSL in Discussions

Deleting and moving JMP data files on disk from JSL

Mon, 29 Oct 2012 09:13:06 GMT

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?

Re: Deleting and moving JMP data files on disk from JSL

gbu — Mon, 29 Oct 2012 10:37:14 GMT

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 )

Re: Deleting and moving JMP data files on disk from JSL

Mon, 29 Oct 2012 11:58:39 GMT

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

Re: Deleting and moving JMP data files on disk from JSL

djhanson — Fri, 19 Apr 2013 15:18:39 GMT

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

Re: Deleting and moving JMP data files on disk from JSL

Stokes — Fri, 03 Feb 2023 05:58:33 GMT

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

Thank you

Re: Deleting and moving JMP data files on disk from JSL

jthi — Fri, 03 Feb 2023 08:20:32 GMT

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

Use Files In Directory() (or some other way) to get a list of file names
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()
Perform action on the filtered list