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.