cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar
UserID16644
Level V

extract the folder name from file directory

How can I extract the folder name from file directory? I will use the folder's name as the name of the data table when saving it. I am using JMP 15.

I tried this piece of code I saw here but still cannot extract the folder name. I

 

Dir = "";

p = pick Directory("Select a Folder", Dir);
f = Files In Directory(p);

Dir = Substr( p, 1, Length( p ) - Length( Word( -1, p, "\/" ) ) - 1 );

Ex. 

File path: C:\Users\Animals

Dir = Animals

1 ACCEPTED SOLUTION

Accepted Solutions
jthi
Super User

Re: extract the folder name from file directory

This should return Animals (at least it does with JMP17)

Names Default To Here(1);

dir = "C:\Users\Animals";
foldername = Word(-1, dir, "\");
show(foldername); // foldername = "Animals";
-Jarmo

View solution in original post

2 REPLIES 2
jthi
Super User

Re: extract the folder name from file directory

This should return Animals (at least it does with JMP17)

Names Default To Here(1);

dir = "C:\Users\Animals";
foldername = Word(-1, dir, "\");
show(foldername); // foldername = "Animals";
-Jarmo
hogi
Level XII

Re: extract the folder name from file directory

Link to (one of) the original post(s):
https://community.jmp.com/t5/Discussions/extracting-the-directory-of-a-jmp-file-in-JSL/m-p/423133/hi... 

 

xx="C:\temp\myfile.txt";
theDirectory = Substr( xx, 1, Length( xx ) - Length( Word( -1, xx, "\/" ) ) - 1 );

//"C:\temp"