The Prism scripting language lets you use these four variables in any command that exports text. They are mostly useful inside of loops.

•%F. The name of the file. This is useful in ForEach loops that import a set of files. %F is the file name before the period.

•%X. The file extension (without the preceding period).

•%S. The name of the current sheet. This is useful when looping over all sheets in a file.  You may also use this variable outside of a loop.

•%N. The loop number. This is useful in simulations, which loop a set number of times.

•%%. This outputs the percent symbol, %.  

These variables can be preceded and/or followed by other text. They can only be used within a script loop. Note there are additional variables you can use when writing text.