topic Re: Files In Directory in Discussions

Files In Directory

jumpyKangaroo — Mon, 02 Jun 2025 20:06:34 GMT

With JMP 17, the Files in Directory script command appears not to work if there are leading numbers, or numbers in the file name. The Watch window returns various errors unless all file names are number free.

<jsl> folderPath = "C:\Users\first.last\documents";

<jsl> fd = Files In Directory( folderPath,1,1 );
<jsl> w = Watch ( fd );

Is this fixed in a different release? Suggestions?

Re: Files In Directory

jthi — Mon, 02 Jun 2025 20:24:08 GMT

I'm having no such issues (using JMP18 though). Is the specific reason for using Watch() instead of Show() for example?

Names Default To Here(1);

folderPath = "$DOCUMENTS";
fd = Files In Directory(folderPath, 1, 1);

show(fd);

Re: Files In Directory

txnelson — Mon, 02 Jun 2025 20:41:08 GMT

I just ran the following example in JMP 17.2 running under Windows11 and had no issues with files with names starting with numbers

names default to here(1);

folderPath = "C:\Users\Jim\Documents\Discussion Groups";

fd = Files In Directory( folderPath,1,1 );

{"0123mike_s.xlsx", "34Yass_Sample_Row6.xlsx", "Chris_Liu", "ConfidenceOwl94",
"mann", "Yass_Sample_Row5.xlsx"}

Re: Files In Directory

jumpyKangaroo — Mon, 02 Jun 2025 20:45:33 GMT

Correction. Seems to be leading zeroes, for example "05 Messages.xls" in the file name that cause an issue in what gets returned in the Watch window.

Re: Files In Directory

mmarchandFSLR — Mon, 02 Jun 2025 21:25:27 GMT

It looks to be an issue with the way the Watch window displays the variables. The variable "fs" is properly defined. No issues appeared until I added the "05 Messages.xls" file. I would just avoid the Watch() function. Show() works in any situation, as far as I can tell.

Names Default to Here( 1 );
dir = "$DOCUMENTS\JMP Scripts\zero test\";
fs = Files in Directory( dir, 1, 1 );
w = Watch( fs );
Show( fs );
//fs = {"0 is smaller than 1", "00five-oh.txt", "0meansinfinity.txt", "Hello World.txt"};

Names Default to Here( 1 );
dir = "$DOCUMENTS\JMP Scripts\zero test\";
fs = Files in Directory( dir, 1, 1 );
w = Watch( fs );
Show( fs );
//fs = {"0 is smaller than 1", "00five-oh.txt", "05 Messages.xls", "0meansinfinity.txt", "Hello World.txt"};

Re: Files In Directory

mmarchandFSLR — Mon, 02 Jun 2025 21:27:22 GMT

Oh, and Watch() behaves the same way in JMP 18.0.1. I ran the test above in 17.2.

Re: Files In Directory

txnelson — Mon, 02 Jun 2025 21:43:02 GMT

I changed my file names where one file starts with "01 23mike_s.xlsx".

Running in JMP 17.2 I have no issue in my watch window

Re: Files In Directory

hogi — Tue, 03 Jun 2025 05:46:16 GMT

Besides watch in the GUI of the debugger, there is a watch() command:

I just checked some files with 0s with JMP v18.2.1:

seems that it's not the 0s, but a line break which causes the issue - after adding another file: