Skip to main content
Skip table of contents

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

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.