- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
JSL Script - How to extract a table cell value and save to variable
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!
1 ACCEPTED SOLUTION
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: JSL Script - How to extract a table cell value and save to variable
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!
Duane Hayes
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: JSL Script - How to extract a table cell value and save to variable
Created:
Aug 10, 2009 06:50 PM
| Last Modified: Aug 24, 2017 5:08 AM
(24533 views)
| Posted in reply to message from trisampson 08-06-2009
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: JSL Script - How to extract a table cell value and save to variable
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!
Duane Hayes