NathanH Valued Newbie
Joined: 05 Sep 2001 Posts: 32
|
Posted: Thu Jul 17, 2003 5:17 pm Post subject: FYI: Getting column info from TABLE element (VDS5) |
|
|
It took me an hour to work out some TABLE issues, and thought I'd jot down my findings, as the help file and sample script don't go into any detail on getting the data of each column into variables.
The code is simply...
Code: | OPTION FIELDSEP,@TAB()
PARSE "%%COLUMN1;%%COLUMN2;%%COLUMN3",@ITEM(TABLE1)
OPTION FIELDSEP,|
|
What threw me was not setting the FIELDSEP option back. If you don't, then the LIST ADD command... ie
Code: | LIST ADD,TABLE1,%%COLUMN1@TAB()%%COLUMN2@TAB()%%COLUMN3 |
...will only add the first column into the table.
If I fix up the tabletest demo script included with VDS5, would Commercial Research be interested in using it in future updates so people have a better example to go by?
Hope that helps someone
Nathan |
|