The WBlock and WTBlock script commands

These commands were ntroduced in GraphPad Prism 6.04 and 6.0e. The idea is to specify a block (range) of cells to write to a text file already specified in an OpenOutput command.

 WBlock script command

Syntax:   WBlock [row(s)]  [column(s)] <row label> <;>

Rows. The parameter for rows can designate a single row, a row down to a blank row, a range of rows , or a list of rows which can be in any order.  You must have used the OpenOutput script command first to specify where the results will be written.

What you enter	How Prism interprets it
7	Only row 7. Of course, row 7 is the row labeled with a 7 in front of it, so row 0 is the column titles.
“7”	Only row 7
“7-“	Start at row 7 and keep going until you hit a blank row
“7-12”	Start at row 7 and end at row 12. Note that the second number is the ending row, not the number of rows.
“7, 11, 9, 8”	Specified rows in that order.

 

Columns. The parameter for columns can designate a single column, a column across until an empty column, a range of columns, or a list of columns which can be in any order.  You must have used the OpenOutput script command first to specify where the results will be written.

What you enter	How Prism interprets it
3	Only column 3. The column of row titles (if it exists) is column 0. Column 1 is column A, but for some results there are no A, B, C column labels.
“3-3”	Only column 3. The column with titles is 0, so in the example above, this is the “significant” column
“3”	Only column 3.
“3-“	Start at column 3 and keep going right until a column is empty (or the end of the table).
“3, 4”	Columns 3 and 4
“3-6”	Columns 3, 4, 5 and 6.
“3, 8, 4”	Columns 3, then 8 then 4. Note that the order in the results will not match the order in the Prism table.  Also note that I included spaces after the commas which are ignored.
“3,8,4”	“

 

Row label. The parameter row label would must be quoted text. That text will appear as the first item in every row output. If the WBlock command ends with a semicolon, then there is no delimeter (no tab, no space, no comma) after that text. If there is no semicolon, then the row label text is separated from the next column just like all the columns are separated (tab unless an alternative is specified in OpenOutput command).  If there is no row label (as it is an optional parameter), then a semicolon at the end of the command is ignored and has no impact. 

 

WTBlock script command

The WTBlock command has the same syntax as WBlock. Note that the label is applied to the row as output (which is a column in the Prism table)

WTBlock [row(s)]  [columns to include] <row label> <;>

Examples

Here are results of one way ANOVA followed by Dunnett's test from Prism 6.04 (the results show two new columns that were not in prior releases):

The results are shown here as tables. In fact, they will be tab-delimited text (or comma delimeted, if that is set in the OpenOutput command).

Example 1

The results will be as shown below. Here it is a table. In fact it will be tab delimited text. (The delimeter is set in the OpenOutput script command, and defaults to tabs).

Psummary	B	****
Psummary	C	ns
Psummary	D	*
Psummary	E	ns
Significant?	B	Yes
Significant?	C	No
Significant?	D	Yes
Significant?	E	No

 

Example 2

The results will be as shown below. Note the semicolon after the labels, so in both cases the label and the columnID column run together.         

PsummaryB	****
PsummaryC	ns
PsummaryD	*
PsummaryE	ns
Significant?B	Yes
Significant?C	No
Significant?D	Yes
Significant?E	No

Example 3

Here thre is no semicolon, so the labels have their own column.

Psummary	Treated	***
Psummary	Treated+Antagonist	ns
Psummary	Treated+Agonist	*
Psummary	Solvent Blank	ns
Significant?	Treated	Yes
Significant?	Treated+Antagonist	No
Significant?	Treated+Agonist	Yes
Significant?	Solvent Blank	No

Example 4

 

Treated	Treated+Antagonist	Treated+Agonist	Solvent Blanks
Yes	No	Yes	No
***	Ns	*	ns

 

Example 5

 

Significant?

Yes

No

Yes

No

 

Prism file