SetVarListFromString: Create a list of variables from the content of a string.
SetVarListFromString constructs a list of variables from the content of a string.
String columns are mapped to variables using SetParam sub-actions (see below SetParam attributes table).
Tag Attributes
Attribute Name | Attribute Value |
---|---|
ListName | Name of list - Required |
Text | Input string. - Required |
SkipRows | Number of rows to skip on top.
|
SkipValue | Input value that allows row skipping. |
Unique | TRUE - Only keep unique variable sets |
OrderAscBy | Variable Name on which to order ascending (cannot be combined with OrderDescBy) |
OrderDescBy | Variable Name on which to order descending (cannot be combined with OrderAscBy) |
Verbose | When set to TRUE, displays a console trace for each element added to the list Defaults to TRUE |
Map columns to variables
One SetParam represents one mapping.
SetParam attributes
Name | Value |
---|---|
Field | Variable Name to map to |
Value | Column index to map from (starting from 0) |
Example script
XML
|