cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
%3CLINGO-SUB%20id%3D%22lingo-sub-776848%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%E5%9C%A8%E5%AF%BC%E5%85%A5%E5%A4%9A%E4%B8%AA%E6%96%87%E4%BB%B6%E6%97%B6%E4%BD%BF%E7%94%A8%E5%8F%98%E9%87%8F%E8%AE%BE%E7%BD%AE%E6%96%87%E4%BB%B6%E5%88%97%E8%A1%A8%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-776848%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3E%E6%88%91%E6%AD%A3%E5%9C%A8%E4%BD%BF%E7%94%A8%20JMP%2018.0.1%EF%BC%8C%E6%88%91%E6%B3%A8%E6%84%8F%E5%88%B0%E2%80%9C%E5%A4%9A%E6%96%87%E4%BB%B6%E5%AF%BC%E5%85%A5%E2%80%9D%E7%9A%84%E6%96%B0%E9%80%89%E9%A1%B9%E5%85%81%E8%AE%B8%E7%94%A8%E6%88%B7%E6%8F%90%E4%BE%9B%E8%A6%81%E5%AF%BC%E5%85%A5%E7%9A%84%E6%96%87%E4%BB%B6%E5%88%97%E8%A1%A8%EF%BC%88%E6%88%96%E7%9B%AE%E5%BD%95%EF%BC%89%E3%80%82%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CP%3E%E6%88%91%E5%8F%AF%E4%BB%A5%E5%9C%A8%E5%A6%82%E4%B8%8B%E8%84%9A%E6%9C%AC%E4%B8%AD%E6%88%90%E5%8A%9F%E4%BD%BF%E7%94%A8%E5%AE%83%EF%BC%9A%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3EMultiple%20File%20Import(%0A%09%26lt%3B%3CSET%20use%3D%22%22%20file%3D%22%22%20list%3D%22%22%3E%3C%2FSET%3E%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%3CCODE%20class%3D%22%20language-jsl%22%3E%20%3C%2FCODE%3E%3C%2FP%3E%3CP%3E%3CCODE%20class%3D%22%20language-jsl%22%3EHowever%2C%20when%20I%20try%20to%20move%20the%20list%20to%20a%20variable%2C%20so%20that%20I%20can%20add%2Fremove%20elements%20dynamically%2C%20the%20import%20stops%20working.%3C%2FCODE%3E%3C%2FP%3E%3CP%3E%3CCODE%20class%3D%22%20language-jsl%22%3E%20%3C%2FCODE%3E%3C%2FP%3E%3CP%3E%3CCODE%20class%3D%22%20language-jsl%22%3E%20%3C%2FCODE%3E%3C%2FP%3E%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3E%3CCODE%20class%3D%22%20language-jsl%22%3EfileList%20%3D%20%7B%20%22C%3A%5Cfile1.csv%22%2C%20%22C%3A%5Cfile2.csv%22%2C%20%22C%3A%5Cfile3.csv%22%20%20%7D%3B%0A%0AMultiple%20File%20Import(%0A%09%26lt%3B%3CSET%20use%3D%22%22%20file%3D%22%22%20list%3D%22%22%3E%3C%2FSET%3E%3C%2FCODE%3E%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%3CCODE%20class%3D%22%20language-jsl%22%3E%3CCODE%20class%3D%22%20language-jsl%22%3E%20%3C%2FCODE%3E%3C%2FCODE%3E%3C%2FP%3E%3CP%3E%3CCODE%20class%3D%22%20language-jsl%22%3E%3CCODE%20class%3D%22%20language-jsl%22%3EThere's%20no%20error%2C%20but%20zero%20tables%20are%20created.%20Even%20when%20I%20replace%20%22Import%20Data%22%20with%20%22%3CSPAN%3E%E5%88%9B%E5%BB%BA%E7%AA%97%E5%8F%A3%E2%80%9D%EF%BC%8C%E6%88%91%E5%8F%91%E7%8E%B0%E5%9C%A8%E7%AC%AC%E4%B8%80%E7%A7%8D%E6%83%85%E5%86%B5%E4%B8%8B%E5%88%97%E8%A1%A8%E5%B7%B2%E5%A1%AB%E5%85%85%EF%BC%8C%E8%80%8C%E5%9C%A8%E7%AC%AC%E4%BA%8C%E7%A7%8D%E6%83%85%E5%86%B5%E4%B8%8B%E5%88%97%E8%A1%A8%E4%BF%9D%E6%8C%81%E4%B8%BA%E7%A9%BA%E3%80%82%3C%2FSPAN%3E%3C%2FCODE%3E%3C%2FCODE%3E%3C%2FP%3E%3CP%3E%3CCODE%20class%3D%22%20language-jsl%22%3E%3CCODE%20class%3D%22%20language-jsl%22%3E%20%3C%2FCODE%3E%3C%2FCODE%3E%3C%2FP%3E%3CP%3E%3CCODE%20class%3D%22%20language-jsl%22%3E%3CCODE%20class%3D%22%20language-jsl%22%3E%3CSPAN%3E%E6%88%91%E6%98%AF%E4%B8%8D%E6%98%AF%E6%BC%8F%E6%8E%89%E4%BA%86%E4%BB%80%E4%B9%88%EF%BC%9F%E6%88%91%E6%98%AF%E4%B8%8D%E6%98%AF%E8%AF%95%E5%9B%BE%E4%BB%A5%E9%94%99%E8%AF%AF%E7%9A%84%E6%96%B9%E5%BC%8F%E8%AE%BE%E7%BD%AE%E6%AD%A4%E9%80%89%E9%A1%B9%EF%BC%9F%3C%2FSPAN%3E%3C%2FCODE%3E%3C%2FCODE%3E%3C%2FP%3E%3CP%3E%3CCODE%20class%3D%22%20language-jsl%22%3E%3CCODE%20class%3D%22%20language-jsl%22%3E%3CSPAN%3E%E8%B0%A2%E8%B0%A2%EF%BC%81%3C%2FSPAN%3E%3C%2FCODE%3E%3C%2FCODE%3E%3C%2FP%3E%3CP%3E%3CCODE%20class%3D%22%20language-jsl%22%3E%3CCODE%20class%3D%22%20language-jsl%22%3E%20%3C%2FCODE%3E%3C%2FCODE%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CCODE%20class%3D%22%20language-jsl%22%3E%3CCODE%20class%3D%22%20language-jsl%22%3E%3CLINGO-LABS%20id%3D%22lingo-labs-776848%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CLINGO-LABEL%3E%E8%87%AA%E5%8A%A8%E5%8C%96%E5%92%8C%E8%84%9A%E6%9C%AC%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FCODE%3E%3C%2FCODE%3E%3CLINGO-SUB%20id%3D%22lingo-sub-776878%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%E5%9B%9E%E5%A4%8D%EF%BC%9A%E5%9C%A8%E5%AF%BC%E5%85%A5%E5%A4%9A%E4%B8%AA%E6%96%87%E4%BB%B6%E6%9C%9F%E9%97%B4%E4%BD%BF%E7%94%A8%E5%8F%98%E9%87%8F%E8%AE%BE%E7%BD%AE%E6%96%87%E4%BB%B6%E5%88%97%E8%A1%A8%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-776878%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3E%E8%BF%99%E6%98%AF%E4%B8%80%E4%B8%AA%E5%B7%B2%E7%9F%A5%E7%9A%84%E9%94%99%E8%AF%AF%EF%BC%9A%3CBR%20%2F%3E%20%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2FJMP-Wish-List%2FAdvanced-syntax-highlighting-in-JSL-Editor-does-the-function%2Fidc-p%2F772428%2Fhighlight%2Ftrue%23M5779%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Fcommunity.jmp.com%2Ft5%2FJMP-Wish-List%2FAdvanced-syntax-highlighting-in-JSL-Editor-does-the-function%2Fidc-p%2F772428%2Fhighlight%2Ftrue%23M5779%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%20JMP%20%E6%94%AF%E6%8C%81%E7%9A%84%E5%9B%9E%E5%A4%8D%EF%BC%88TS-00152969%EF%BC%89%EF%BC%9B%3CBR%20%2F%3E%3CEM%3E%E6%88%91%E5%B7%B2%E7%BB%8F%E4%B8%8E%E5%BC%80%E5%8F%91%E9%83%A8%E9%97%A8%E8%AE%A8%E8%AE%BA%E8%BF%87%E8%BF%99%E4%B8%AA%E9%97%AE%E9%A2%98%E3%80%82%E8%BF%99%E4%B8%AA%E9%97%AE%E9%A2%98%E6%98%AF%E4%B8%80%E4%B8%AA%E7%BC%BA%E9%99%B7%EF%BC%8C%E6%88%91%E5%B7%B2%E5%B0%86%E5%85%B6%E6%8A%A5%E5%91%8A%E7%BB%99%E5%BC%80%E5%8F%91%E9%83%A8%E9%97%A8%EF%BC%8C%E4%BB%A5%E4%BE%BF%E5%9C%A8%E6%9C%AA%E6%9D%A5%E7%9A%84%20JMP%20%E7%89%88%E6%9C%AC%E4%B8%AD%E8%A7%A3%E5%86%B3%E3%80%82%3C%2FEM%3E%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2FJMP-Wish-List%2FAdvanced-syntax-highlighting-in-JSL-Editor-does-the-function%2Fm-p%2F729460%23U729460%22%20class%3D%22lia-mention-container-editor-message%20lia-img-icon-idea-thread%20lia-fa-icon%20lia-fa-idea%20lia-fa-thread%20lia-fa%22%20target%3D%22_blank%22%3EJSL%20%E7%BC%96%E8%BE%91%E5%99%A8%E4%B8%AD%E7%9A%84%E9%AB%98%E7%BA%A7%E8%AF%AD%E6%B3%95%E7%AA%81%E5%87%BA%E6%98%BE%E7%A4%BA%20-%20%E5%87%BD%E6%95%B0%E6%98%AF%E5%90%A6%E8%AF%84%E4%BC%B0%E5%85%B6%E5%8F%82%E6%95%B0%EF%BC%9F%3C%2FA%3E%E5%8F%AF%E4%BB%A5%E5%B8%AE%E5%8A%A9%E6%89%BE%E5%87%BA%E5%8F%82%E6%95%B0%E7%9A%84%E8%AF%84%E4%BC%B0%E7%BA%A7%E5%88%AB%E4%BB%A5%E5%8F%8A%E6%98%AF%E5%90%A6%E9%9C%80%E8%A6%81%20Eval%20%E6%88%96%E6%9B%B4%E5%A4%8D%E6%9D%82%E7%9A%84%E7%BB%93%E6%9E%84%EF%BC%8C%E5%A6%82%20Substitute%20(Expr()%2C%20...)%20%E6%88%96%20Eval(Eval%20Expr(....%20Expr(arg)....%20))%20-%20%E5%B0%B1%E5%83%8F%E5%9C%A8%E8%BF%99%E7%A7%8D%E6%83%85%E5%86%B5%E4%B8%8B%E4%B8%80%E6%A0%B7%E3%80%82%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CP%3E%E9%99%A4%E4%BA%86%E9%AB%98%E7%BA%A7%E8%AF%AD%E6%B3%95%E9%AB%98%E4%BA%AE%E6%98%BE%E7%A4%BA%E4%B9%8B%E5%A4%96%EF%BC%8C%E5%AF%B9%E4%BA%8E%E5%BF%85%E9%A1%BB%E4%BD%BF%E7%94%A8%E5%A4%8D%E6%9D%82%E7%BB%93%E6%9E%84%E7%9A%84%E5%8F%82%E6%95%B0%EF%BC%8CJSL%20%E7%BC%96%E8%BE%91%E5%99%A8%E8%BF%98%E5%8F%AF%E4%BB%A5%E7%9B%B4%E6%8E%A5%E6%98%BE%E7%A4%BA%E7%BC%BA%E5%B0%91%E6%AD%A4%E8%AF%AD%E6%B3%95%E7%9A%84%E8%AD%A6%E5%91%8A%E3%80%82%E9%9C%80%E8%A6%81%20Eval%20(arg)%20%E7%9A%84%E6%83%85%E5%86%B5%E4%B9%9F%E6%98%AF%E5%A6%82%E6%AD%A4%E3%80%82%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CP%3E%E7%BC%96%E5%89%A7%E4%BB%AC%EF%BC%8C%E8%AF%B7%E4%B8%BA%E8%BF%99%E4%B8%AA%E6%84%BF%E6%9C%9B%E7%82%B9%E4%B8%AA%20Kudo%EF%BC%81%3CBR%20%2F%3E%E4%B8%80%E6%97%A6%E6%96%B0%E5%8A%9F%E8%83%BD%E5%8F%AF%E7%94%A8%EF%BC%8CJSL%20%E4%B8%AD%E7%9A%84%E8%A1%A8%E8%BE%BE%E5%BC%8F%E5%A4%84%E7%90%86%E5%B0%86%E4%BC%9A%E5%BE%88%3CU%3E%3CSTRONG%3E%E6%9C%89%E8%B6%A3%3C%2FSTRONG%3E%3C%2FU%3E%E3%80%82%3C%2FP%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar
simopod
Level I

Set File List with a variable during Multiple File Import

I'm using JMP 18.0.1 and I noticed the new option for Multiple File Import that allows the user to provide a list files (or directories) to import.

 

I can successfully use it in a script like so:

 

Multiple File Import(
	<<Set Use File List( 1 ),
	<<Set File List( { "C:\file1.csv", "C:\file2.csv", "C:\file3.csv"  } ),
	<<Set Import Mode( "CSVData" ),
	<<Set Stack Mode( "Stack Similar" ),
) << Import Data;

 

However, when I try to move the list to a variable, so that I can add/remove elements dynamically, the import stops working.

 

 

fileList = { "C:\file1.csv", "C:\file2.csv", "C:\file3.csv"  };

Multiple File Import(
	<<Set Use File List( 1 ),
	<<Set File List( fileList ),
	<<Set Import Mode( "CSVData" ),
	<<Set Stack Mode( "Stack Similar" ),
) << Import Data;

 

There's no error, but zero tables are created. Even when I replace "Import Data" with "Create Window", I see that in the first case the list is populated, whereas it stays empty in the second case.

 

Am I missing something here? Am I trying to set this option in the wrong way?

Thanks!

 

1 REPLY 1
hogi
Level XII

Re: Set File List with a variable during Multiple File Import

this is a known bug:
https://community.jmp.com/t5/JMP-Wish-List/Advanced-syntax-highlighting-in-JSL-Editor-does-the-funct... 

Reply from JMP support (TS - 00152969);
I've spoken with Development about the issue. The issue is a defect and I have reported it to Development so it can be resolved in a future JMP version.

 

Advanced syntax highlighting in JSL Editor - does the function evaluate it's argument?  could help to find out to which level an argument is evaluated and if Eval is needed or a more complex structure like Substitute (Expr(), ...) or Eval(Eval Expr(.... Expr(arg).... ))  - like in this case.

 

Besides advanced syntax highlighting - for arguments where such a complex structure is mandatory, JSL Editor could directly show a warning that this syntax is missing. Same for cases where Eval (arg) is needed.

 

Scripters, please give the wish a Kudo!
Expression handling in JSL will be fun once the new functionality is available.