- Excel Desktop Client new !
The list size or number of expand iterations for a REPEATED EXPAND is determined from the size of the LIST(s) in Value:.
All LIST references in Value: or File: must be the same length.
The default Expansion Separator: is a comma (,).
|Value:||Sequence of literal text and object references to expand into one or more lines for insertion into a batch input file.|
|File:||Name of file containing line(s) of text used instead of Value: (object references allowed)|
|Delimiter:||Character to delimit SCALAR or LIST references in Value: above. default→%|
|Expansion Separator:||Separator used between the values in the list when expanding it. default→comma (,)|
|Encoding:||Text encoding used in File: default→US-ASCII|
|Value on Error:||Value to return if the expansion fails|
If multiple lines of text are entered for the Value: parameter, the new lines created by typing the <ENTER> are displayed in the parameter table as spaces.
Expansion Separator: defines the string inserted between successive iterations of the resulting REPEATED EXPAND. Some possible separators are:
To create a single line of output per 'expand' iteration use a <NEWLINE> separator. This is useful to create input for a batch process or on a results page. A <NEWLINE> typed into the Expansion Separator: field in the parameter window will be displayed as a space. To see <NEWLINE> displayed as a blank line, open the Long Text 'popup' window. Click ellipsis icon () and type the <ENTER> key, <NEWLINE> behaves as expected with the cursor now below the blank line.