Strip path: how to get a directory from a file path variable in JMP script

jtandrews3 — Wed, 07 Dec 2016 18:57:04 GMT

I would like to get the directory from a file path variable in my JMP script.

I'm opening a data file and want to save the analysis results in the same folder that the file is in.

I've found a clunky solution, but was hoping there was a more elegant solution for this.

Here's my current code:

// Choose the directory that has the test data. 
EMfile = Pick File("Select the file containing the EM summary table.");
// The next code is a clumsy way to get the directory of EMfile, but it works. 
a = 1;
b = 1;
while (a != 0,
  b = a+1;
  a = munger(EMfile, b, "/");
);
b--;
file_dir = munger(EMfile, 0, b);

Re: Strip path: how to get a directory from a file path variable in JMP script

txnelson — Sun, 25 Aug 2019 13:07:12 GMT

here is a fairly clean pice of code that does what you want

filelength = length(word(-1,emfile,"\/"));
pathlength=length(emfile)-filelength-1;
path=substr(emfile,1,pathlength);

it can be collapsed into one statement if desired

topic Re: Strip path: how to get a directory from a file path variable in JMP script in Discussions

Strip path: how to get a directory from a file path variable in JMP script

Re: Strip path: how to get a directory from a file path variable in JMP script