KNOWLEDGEBASE - ARTICLE #1531

Variables in Prism scripts.

 The Prism scripting language lets you use these four variables in any command that exports text..

  • %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.
  • %S. The name of the current sheet. This is useful when looping over all sheets in a file.
  • %N. The loop number. This is useful in simulations, which loop a set number of times. 

These variables can be preceded and/or followed by other text. They can only be used within a script loop.

Bug: In versions of Prism 5 up to 5.02 and 5.0b, it is not possible to use any variable names in the ExportTable command. 

Explore the Knowledgebase

Analyze, graph and present your scientific work easily with GraphPad Prism. No coding required.