Assigning String Variables to Pipeline Variables
In addition to assigning a literal value to a variable, you can assign the value of another String variable to a pipeline variable of type String, String List, or String Table. You might do this if you wanted to derive the default value from a variable that exists in the pipeline at run time.
To specify a String variable as the value for a pipeline variable, you enclose the name of the String variable in % symbols (for example, %Phone%) and then select the Perform pipeline variable substitution check box.
Keep the following information in mind when using pipeline variable substitution:
![*](chapterTOC_bullet.png)
You can use String variables to specify values for pipeline variables of type String, String List, and String Table only.
![*](chapterTOC_bullet.png)
You must select the
Perform pipeline variable substitution check box for the variable substitution to occur.
![*](chapterTOC_bullet.png)
You can mix literal values with String variables. For example, if you specify
(%areaCode%) %Phone%, the resulting String would be formatted to include the parentheses and space. If you specify
%firstName% %initial%. %lastName%, the period and spacing would be included in the value.
![*](chapterTOC_bullet.png)
If the variable name that you specify between % does not exist in the pipeline at run time, no variable substitution occurs. Instead, the value of the pipeline variable will be
%StringVariableName%. If you specify
%lastName% as the value for the
familyName variable, and the
lastName variable does not exist in the pipeline at run time, the
familyName variable value is:
%lastName%