$list from table 2

Allows you to return the contents of a specified row or column as list items.


Example

Running this code will create a table named "&table" from the file "C:\Users\user\Desktop\test.csv". Clear list commands will be applied to the script to always update if the "test.csv" is edited.

The index number 1 column of "&table" will be in the "%listFromCol".

The index number 1 column of "&table" will be in the "%listFromRow".

This is shown in the Debugger.

create table from file("C:\\Users\\user\\Desktop\\test.csv",&table)
clear list(%listFromRow)
clear list(%listFromCol)
add list to list(%listFromCol,$plugin function("Data and Files Automation.dll", "$list from table 2", &table, "Column", 1),"Delete","Global")
add list to list(%listFromRow,$plugin function("Data and Files Automation.dll", "$list from table 2", &table, "Row", 1),"Delete","Global")

Was this helpful?

Previous Article

$list from file 2