cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Discussions

Solve problems, and share tips and tricks with other JMP users.
%3CLINGO-SUB%20id%3D%22lingo-sub-448468%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20%E5%A6%82%E4%BD%95%E5%BE%9E%E6%96%87%E4%BB%B6%E5%A4%BE%E4%B8%AD%E7%8D%B2%E5%8F%96%E5%85%B7%E6%9C%89%E7%89%B9%E5%AE%9A%E5%BE%8C%E7%B6%B4%E7%9A%84%E6%96%87%E4%BB%B6%E5%90%8D%EF%BC%9F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-448468%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E5%A5%BD%E7%9A%84%EF%BC%81%20%E7%8F%BE%E5%9C%A8%E6%88%91%E9%9C%80%E8%A6%81%E5%8E%BB%E9%96%B1%E8%AE%80%20Filter%20Each%EF%BC%9A%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Filter%20Each%20for%20JMP%2016%20in%20Help-%26gt%3BScripting%20Index%22%20style%3D%22width%3A%20999px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Filter%20Each%20for%20JMP%2016%20in%20Help-%26gt%3BScripting%20Index%22%20style%3D%22width%3A%20999px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Filter%20Each%20for%20JMP%2016%20in%20Help-%26gt%3BScripting%20Index%22%20style%3D%22width%3A%20999px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Filter%20Each%20for%20JMP%2016%20in%20Help-%26gt%3BScripting%20Index%22%20style%3D%22width%3A%20999px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Filter%20Each%20for%20JMP%2016%20in%20Help-%26gt%3BScripting%20Index%22%20style%3D%22width%3A%20999px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Filter%20Each%20for%20JMP%2016%20in%20Help-%26gt%3BScripting%20Index%22%20style%3D%22width%3A%20999px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Filter%20Each%20for%20JMP%2016%20in%20Help-%26gt%3BScripting%20Index%22%20style%3D%22width%3A%20999px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Filter%20Each%20for%20JMP%2016%20in%20Help-%26gt%3BScripting%20Index%22%20style%3D%22width%3A%20999px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Filter%20Each%20for%20JMP%2016%20in%20Help-%26gt%3BScripting%20Index%22%20style%3D%22width%3A%20999px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Filter%20Each%20for%20JMP%2016%20in%20Help-%26gt%3BScripting%20Index%22%20style%3D%22width%3A%20999px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Filter%20Each%20for%20JMP%2016%20in%20Help-%26gt%3BScripting%20Index%22%20style%3D%22width%3A%20999px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F38689i3086EB41D22F1E98%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Capture.PNG%22%20alt%3D%22Filter%20Each%20for%20JMP%2016%20in%20Help-%26gt%3BScripting%20Index%22%20%2F%3E%3Cspan%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EFilter%20Each%20for%20JMP%2016%20in%20Help-%26gt%3BScripting%20Index%3C%2Fspan%3E%3C%2Fspan%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EFilter%20Each%20for%20JMP%2016%20in%20Help-%26gt%3BScripting%20Index%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EFilter%20Each%20for%20JMP%2016%20in%20Help-%26gt%3BScripting%20Index%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EFilter%20Each%20for%20JMP%2016%20in%20Help-%26gt%3BScripting%20Index%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EFilter%20Each%20for%20JMP%2016%20in%20Help-%26gt%3BScripting%20Index%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EFilter%20Each%20for%20JMP%2016%20in%20Help-%26gt%3BScripting%20Index%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EFilter%20Each%20for%20JMP%2016%20in%20Help-%26gt%3BScripting%20Index%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EFilter%20Each%20for%20JMP%2016%20in%20Help-%26gt%3BScripting%20Index%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EFilter%20Each%20for%20JMP%2016%20in%20Help-%26gt%3BScripting%20Index%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EFilter%20Each%20for%20JMP%2016%20in%20Help-%26gt%3BScripting%20Index%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3E%E5%9C%A8%E5%B9%AB%E5%8A%A9-%26gt%3B%20%E8%85%B3%E6%9C%AC%E7%B4%A2%E5%BC%95%E4%B8%AD%E7%82%BA%20JMP%2016%20%E9%81%8E%E6%BF%BE%E6%AF%8F%E5%80%8B%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%E8%85%B3%E6%9C%AC%E7%B4%A2%E5%BC%95%E6%9C%89%E4%B8%89%E5%80%8B%E4%BE%8B%E5%AD%90%EF%BC%9B%E9%97%9C%E8%81%AF%E6%95%B8%E7%B5%84%E7%A4%BA%E4%BE%8B%E5%9C%A8%E5%9C%96%E7%89%87%E4%B8%AD%E3%80%82%20%E6%88%91%E5%96%9C%E6%AD%A1%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F14366%22%20target%3D%22_blank%22%3E%40jthi%3C%2FA%3E%20example%20%E5%9B%A0%E7%82%BA%E5%AE%83%E6%9A%97%E7%A4%BA%E9%81%B8%E6%93%87%E9%A0%85%E7%9B%AE%E7%9A%84%E8%A1%A8%E9%81%94%E5%BC%8F%E5%8F%AF%E4%BB%A5%E6%9B%B4%E8%A4%87%E9%9B%9C%E3%80%82%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-448465%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20%E5%A6%82%E4%BD%95%E5%BE%9E%E6%96%87%E4%BB%B6%E5%A4%BE%E4%B8%AD%E7%8D%B2%E5%8F%96%E5%85%B7%E6%9C%89%E7%89%B9%E5%AE%9A%E5%BE%8C%E7%B6%B4%E7%9A%84%E6%96%87%E4%BB%B6%E5%90%8D%EF%BC%9F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-448465%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E6%82%A8%E5%8F%AF%E4%BB%A5%E5%98%97%E8%A9%A6%E4%BD%BF%E7%94%A8%E5%BE%9E%E6%96%87%E4%BB%B6%2F%E5%B0%8E%E5%85%A5%E5%A4%9A%E5%80%8B%E6%96%87%E4%BB%B6%E4%B8%AD%E6%89%BE%E5%88%B0%E7%9A%84%E5%A4%9A%E5%80%8B%E6%96%87%E4%BB%B6%E5%B0%8E%E5%85%A5...%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22jthi_0-1640934626650.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1640934626650.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1640934626650.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1640934626650.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1640934626650.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1640934626650.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1640934626650.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1640934626650.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1640934626650.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1640934626650.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22jthi_0-1640934626650.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F38687i00409402E661F80F%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22jthi_0-1640934626650.png%22%20alt%3D%22jthi_0-1640934626650.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%E6%88%96%E5%9C%A8%E9%81%8E%E6%BF%BE%E6%8E%89%E4%B8%8D%E9%9C%80%E8%A6%81%E7%9A%84%E7%B5%90%E6%9E%9C%E6%99%82%E5%BE%AA%E7%92%B0%E9%81%8D%E6%AD%B7%E6%82%A8%E6%93%81%E6%9C%89%E7%9A%84%E5%88%97%E8%A1%A8%E3%80%82%3C%2FP%3E%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3ENames%20Default%20To%20Here(1)%3B%0A%0AfileNames%20%3D%20%7B%22test0.s2p%22%2C%20%22test.jmp%22%2C%20%22test1.jsl%22%2C%20%22test2.s2p%22%7D%3B%0Asuffix_of_interest%20%3D%20%22.s2p%22%3B%0A%0A%2F%2FJMP16%0Afiles_of_interest%20%3D%20Filter%20Each(%7Bval%7D%2C%20fileNames%2C%20Ends%20With(val%2C%20suffix_of_interest))%3B%0Ashow(files_of_interest)%3B%0A%0A%2F%2Fearlier%0Afiles_of_interest2%20%3D%20%7B%7D%3B%0AFor(i%20%3D%201%2C%20i%20%26lt%3B%3D%20N%20Items(fileNames)%2C%20i%2B%2B%2C%0A%20val%20%3D%20fileNames%5Bi%5D%3B%0A%20If(Ends%20With(val%2C%20suffix_of_interest)%2C%0A%20%20Insert%20Into(files_of_interest2%2C%20val)%3B%0A%20)%3B%0A)%3B%0Ashow(files_of_interest2)%3B%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-448440%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%E5%A6%82%E4%BD%95%E5%BE%9E%E6%96%87%E4%BB%B6%E5%A4%BE%E4%B8%AD%E7%8D%B2%E5%8F%96%E5%85%B7%E6%9C%89%E7%89%B9%E5%AE%9A%E5%BE%8C%E7%B6%B4%E7%9A%84%E6%96%87%E4%BB%B6%E5%90%8D%EF%BC%9F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-448440%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E6%88%91%E6%AD%A3%E5%9C%A8%E5%98%97%E8%A9%A6%E5%BE%9E%E6%96%87%E4%BB%B6%E5%A4%BE%E5%B0%8E%E5%85%A5%E4%B8%80%E4%BA%9B%E6%95%B8%E6%93%9A%EF%BC%8C%E5%AE%83%E5%8C%85%E5%90%AB%E4%B8%8D%E5%90%8C%E9%A1%9E%E5%9E%8B%E7%9A%84%E6%96%87%E4%BB%B6%EF%BC%8C%E8%80%8C%E6%88%91%E5%8F%AA%E6%83%B3%E8%A6%81%E5%B8%B6%E6%9C%89%20*.s2p%20%E5%BE%8C%E7%B6%B4%E7%9A%84%E6%96%87%E4%BB%B6%EF%BC%8C%E5%A6%82%E4%BD%95%E7%8D%B2%E5%8F%96%E6%89%80%E6%9C%89%E5%B8%B6%E6%9C%89%20.s2p%20%E5%BE%8C%E7%B6%B4%E7%9A%84%E6%96%87%E4%BB%B6%E5%90%8D%EF%BC%9F%E6%88%91%E4%BD%BF%E7%94%A8%E7%9B%AE%E9%8C%84%E4%B8%AD%E7%9A%84%E6%96%87%E4%BB%B6%E5%8A%9F%E8%83%BD%EF%BC%8C%E4%BD%86%E5%AE%83%E5%8F%AA%E8%83%BD%E7%8D%B2%E5%8F%96%E6%89%80%E6%9C%89%E6%96%87%E4%BB%B6%E5%90%8D%E3%80%82%3C%2FP%3E%3CPRE%3EfileNames%20%3D%20Files%20In%20Directory(%20directory%20)%3B%20%20%20%20%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-448440%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CLINGO-LABEL%3E%E6%B6%88%E8%B2%BB%E8%80%85%E5%92%8C%E5%B8%82%E5%A0%B4%E7%A0%94%E7%A9%B6%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3E%E5%85%A7%E5%AE%B9%E7%B5%84%E7%B9%94%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3E%E6%95%B8%E6%93%9A%E5%AD%98%E5%8F%96%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3E%E8%B3%AA%E9%87%8F%E5%92%8C%E5%B7%A5%E8%97%9D%E5%B7%A5%E7%A8%8B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Choose Language Hide Translation Bar
Jiaxiang
Level I

How do I get the file names with a specific suffix from a folder?

I am trying to import some data from a folder, it contains different type of files, and I just want the file with *.s2p suffix, how can I  get all the filename with  .s2p  suffix?  I use files in directory function, but it can only get all the filename.

fileNames = Files In Directory( directory );    
2 REPLIES 2
jthi
Super User

Re: How do I get the file names with a specific suffix from a folder?

You could try using Multiple File Import found from File / Import Multiple Files...

jthi_0-1640934626650.png

 

or loop over the list you have while filtering out non-wanted results.

Names Default To Here(1);

fileNames = {"test0.s2p", "test.jmp", "test1.jsl", "test2.s2p"};
suffix_of_interest = ".s2p";

//JMP16
files_of_interest = Filter Each({val}, fileNames, Ends With(val, suffix_of_interest));
show(files_of_interest);

//earlier
files_of_interest2 = {};
For(i = 1, i <= N Items(fileNames), i++,
	val = fileNames[i];
	If(Ends With(val, suffix_of_interest),
		Insert Into(files_of_interest2, val);
	);
);
show(files_of_interest2);

 

-Jarmo
Craige_Hales
Super User

Re: How do I get the file names with a specific suffix from a folder?

Nice! Now I need to go read about Filter Each:

Filter Each for JMP 16 in Help->Scripting IndexFilter Each for JMP 16 in Help->Scripting Index

The scripting index has three examples; the Associative Array example is in the picture. I like  @jthi  example because it hints that the expression for selecting items can be more complicated.

 

Craige

Recommended Articles