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-776848%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%E5%9C%A8%E5%A4%9A%E5%80%8B%E6%96%87%E4%BB%B6%E5%B0%8E%E5%85%A5%E6%9C%9F%E9%96%93%E4%BD%BF%E7%94%A8%E8%AE%8A%E6%95%B8%E8%A8%AD%E5%AE%9A%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%E5%A4%9A%E6%AA%94%E6%A1%88%E5%8C%AF%E5%85%A5%E7%9A%84%E6%96%B0%E9%81%B8%E9%A0%85%E5%85%81%E8%A8%B1%E4%BD%BF%E7%94%A8%E8%80%85%E6%8F%90%E4%BE%9B%E8%A6%81%E5%8C%AF%E5%85%A5%E7%9A%84%E6%AA%94%E6%A1%88%EF%BC%88%E6%88%96%E7%9B%AE%E9%8C%84%EF%BC%89%E6%B8%85%E5%96%AE%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%E8%85%B3%E6%9C%AC%E4%B8%AD%E6%88%90%E5%8A%9F%E4%BD%BF%E7%94%A8%E5%AE%83%EF%BC%8C%E5%A6%82%E4%B8%8B%E6%89%80%E7%A4%BA%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%BB%BA%E7%AB%8B%E8%A6%96%E7%AA%97%E2%80%9D%EF%BC%8C%E6%88%91%E7%9C%8B%E5%88%B0%E5%9C%A8%E7%AC%AC%E4%B8%80%E7%A8%AE%E6%83%85%E6%B3%81%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%A8%AE%E6%83%85%E6%B3%81%E4%B8%8B%E5%88%97%E8%A1%A8%E4%BF%9D%E6%8C%81%E7%82%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%E5%9C%A8%E9%80%99%E8%A3%A1%E9%8C%AF%E9%81%8E%E4%BA%86%E4%BB%80%E9%BA%BC%E5%97%8E%EF%BC%9F%E6%88%91%E6%98%AF%E5%90%A6%E5%98%97%E8%A9%A6%E4%BB%A5%E9%8C%AF%E8%AA%A4%E7%9A%84%E6%96%B9%E5%BC%8F%E8%A8%AD%E5%AE%9A%E6%AD%A4%E9%81%B8%E9%A0%85%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%AC%9D%E8%AC%9D%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%8B%95%E5%8C%96%E5%92%8C%E8%85%B3%E6%9C%AC%E7%B7%A8%E5%AF%AB%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%E8%A6%86%EF%BC%9A%E5%9C%A8%E5%A4%9A%E5%80%8B%E6%96%87%E4%BB%B6%E5%8C%AF%E5%85%A5%E6%9C%9F%E9%96%93%E4%BD%BF%E7%94%A8%E8%AE%8A%E6%95%B8%E8%A8%AD%E5%AE%9A%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%E9%80%99%E6%98%AF%E4%B8%80%E5%80%8B%E5%B7%B2%E7%9F%A5%E7%9A%84%E9%8C%AF%E8%AA%A4%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%8F%B4%E4%BA%BA%E5%93%A1%E7%9A%84%E5%9B%9E%E6%87%89%20(TS%20-%2000152969)%EF%BC%9B%3CBR%20%2F%3E%3CEM%3E%E6%88%91%E5%B7%B2%E7%B6%93%E8%88%87%E9%96%8B%E7%99%BC%E9%83%A8%E8%A8%8E%E8%AB%96%E9%81%8E%E9%80%99%E5%80%8B%E5%95%8F%E9%A1%8C%E3%80%82%E8%A9%B2%E5%95%8F%E9%A1%8C%E6%98%AF%E4%B8%80%E5%80%8B%E7%BC%BA%E9%99%B7%EF%BC%8C%E6%88%91%E5%B7%B2%E5%B0%87%E5%85%B6%E5%A0%B1%E5%91%8A%E7%B5%A6%E9%96%8B%E7%99%BC%E4%BA%BA%E5%93%A1%EF%BC%8C%E4%BB%A5%E4%BE%BF%E5%8F%AF%E4%BB%A5%E5%9C%A8%E6%9C%AA%E4%BE%86%E7%9A%84%20JMP%20%E7%89%88%E6%9C%AC%E4%B8%AD%E8%A7%A3%E6%B1%BA%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%B7%A8%E8%BC%AF%E5%99%A8%E4%B8%AD%E7%9A%84%E9%AB%98%E7%B4%9A%E8%AA%9E%E6%B3%95%E7%AA%81%E5%87%BA%E9%A1%AF%E7%A4%BA%20-%20%E5%87%BD%E6%95%B8%E6%98%AF%E5%90%A6%E8%A9%95%E4%BC%B0%E5%85%B6%E5%8F%83%E6%95%B8%EF%BC%9F%3C%2FA%3E%E5%8F%AF%E4%BB%A5%E5%B9%AB%E5%8A%A9%E6%89%BE%E5%87%BA%E5%8F%83%E6%95%B8%E8%A9%95%E4%BC%B0%E7%9A%84%E5%B1%A4%E7%B4%9A%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%E8%A4%87%E9%9B%9C%E7%9A%84%E7%B5%90%E6%A7%8B%EF%BC%8C%E4%BE%8B%E5%A6%82%20Substitute%20(Expr()%2C%20...)%20%E6%88%96%20Eval(Eval%20Expr(....%20Expr(arg)...%20)%EF%BC%89%20-%20%E5%B0%B1%E5%83%8F%E9%80%99%E7%A8%AE%E6%83%85%E6%B3%81%E4%B8%80%E6%A8%A3%E3%80%82%3C%2FP%3E%3CP%3E%20%3C%2FP%3E%3CP%3E%E9%99%A4%E4%BA%86%E9%AB%98%E7%B4%9A%E8%AA%9E%E6%B3%95%E7%AA%81%E5%87%BA%E9%A1%AF%E7%A4%BA%E4%B9%8B%E5%A4%96%20-%20%E5%B0%8D%E6%96%BC%E5%BC%B7%E5%88%B6%E4%BD%BF%E7%94%A8%E5%A6%82%E6%AD%A4%E8%A4%87%E9%9B%9C%E7%B5%90%E6%A7%8B%E7%9A%84%E5%8F%83%E6%95%B8%EF%BC%8CJSL%20%E7%B7%A8%E8%BC%AF%E5%99%A8%E9%82%84%E5%8F%AF%E4%BB%A5%E7%9B%B4%E6%8E%A5%E9%A1%AF%E7%A4%BA%E7%BC%BA%E5%B0%91%E6%AD%A4%E8%AA%9E%E6%B3%95%E7%9A%84%E8%AD%A6%E5%91%8A%E3%80%82%E5%B0%8D%E6%96%BC%E9%9C%80%E8%A6%81%20Eval%20(arg)%20%E7%9A%84%E6%83%85%E6%B3%81%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%B7%A8%E5%8A%87%E5%80%91%EF%BC%8C%E8%AB%8B%E7%82%BA%E9%80%99%E5%80%8B%E9%A1%98%E6%9C%9B%E9%BB%9E%E5%80%8B%E5%B7%A5%E8%97%A4%E5%90%A7%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%E9%81%94%E5%BC%8F%E8%99%95%E7%90%86%E5%B0%87%E6%9C%83%E8%AE%8A%E5%BE%97%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 XIII

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.

Recommended Articles