Please enable JavaScript to view this site.

Navigation: Scripts > Script details

The WBlock and WTBlock script commands

Scroll Prev Top Next More

These commands were introduced 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 each row as output (which is each 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):

clip0063

 

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

 

WBlock "7-", "6,4", "PSummary"

WBlock "7-", "6,3", "Significant?"

 

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

 

WBlock "7-", "6,4", "PSummary";

WBlock "7-", "6,3", "Significant?";

 

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

 

WBlock "7-", "7,4", "PSummary"

WBlock "7-", "7,3", "Significant?"  

 

Here there 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

 

WTBlock "7-", “7,3,4”

 

Treated

Treated+Antagonist

Treated+Agonist

Solvent Blanks

Yes

No

Yes

No

***

Ns

*

ns

 

Example 5

 

WTBlock, “7-“, 3, “Significant?”

 

 

Significant?

Yes

No

Yes

No

 

Prism file

 

 

 

 

 

© 1995-2019 GraphPad Software, LLC. All rights reserved.