topic Re: JSL Script - How to extract a table cell value and save to variable in Discussions

JSL Script - How to extract a table cell value and save to variable

trisampson — Thu, 31 Aug 2017 08:29:47 GMT

Hi all,

I have a script that opens up several temporary data tables (csv files) and then saves my analysis to a journal window. I would like to save the journal to an HTML file, but I need to save the filename with a value from one of the data tables. I'm not sure how to save a table value to a variable:

NewWindow("PartJournal",<PartData = Open ("C:\...path...\filename.csv");
row()=1;
filename=Column("Customer");
... other tables opened and results saved to journal ...
filepath = "C:\...path...\" || filename || ".html";
Current Journal() << Save HTML(char(filepath));

Thanks in advance!

Re: JSL Script - How to extract a table cell value and save to variable

Thu, 24 Aug 2017 12:08:07 GMT

Hey, the syntax I use to get a value out of a table is this:

rowNum = 1;
col = Column( Current Data Table(), columnName);
tableVal = col[ rowNum ];

Hope this helps!

Re: JSL Script - How to extract a table cell value and save to variable

Duane_Hayes — Tue, 26 Sep 2017 13:52:01 GMT

As stated above:

Hey, the syntax I use to get a value out of a table is this:

rowNum = 1;
col = Column( Current Data Table(), columnName);
tableVal = col[ rowNum ];

Hope this helps!