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. E.g.: SkipRows="0" (default) -> reads from the 1st line SkipRows="2" (default) -> reads from the 3rd line
SkipValue	Input value that allows row skipping. If a row contains it, the whole row is skipped.
Unique	TRUE - Only keep unique variable sets "Any variable name" - Only keep sets with unique value for this variable
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

<ytriaAutomation Application="sapio365">
	<SetVarFromTextFile name="xLOCAL_SPO_Output" filepath="SHARK-2797.txt"/>
	<SetVarListFromString Text='{%xLOCAL_SPO_Output%}' ListName='tmp_StringData' SkipRows='0'>
		<SetParam Field='v_DisplayName' Value='0'/>
		<SetParam Field='v_UserType' Value='1'/>
		<SetParam Field='v_LoginName' Value='2'/>
		<SetParam Field='v_IsSiteAdmin' Value='3'/>
		<SetParam Field='v_Groups' Value='4'/>
		<SetParam Field='v_IsGroup' Value='5'/>
	</SetVarListFromString>
</ytriaAutomation>

SHARK-2797.txt