topic Re: extract the folder name from file directory in Discussions

extract the folder name from file directory

UserID16644 — Tue, 31 Oct 2023 06:08:29 GMT

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

Re: extract the folder name from file directory

jthi — Tue, 31 Oct 2023 06:30:38 GMT

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";

Re: extract the folder name from file directory

hogi — Tue, 31 Oct 2023 11:59:35 GMT

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/highlight/true#M67228

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

//"C:\temp"