TIP: If your data is not TAB delimited, use Text Manipulation->Convert

What it does

This tool computes an expression for every row of a query and appends the result as a new column (field).

• Columns are referenced with c and a number. For example, c1 refers to the first column of a tab-delimited file
• c3-c2 will add a length column to the query if c2 and c3 are start and end position

Example

If this is your input:

chr1  151077881  151077918  2  200  -
chr1  151081985  151082078  3  500  +

computing "c4*c5" will produce:

chr1  151077881  151077918  2  200  -   400.0
chr1  151081985  151082078  3  500  +  1500.0

if, at the same time, "Round result?" is set to YES results will look like this:

chr1  151077881  151077918  2  200  -   400
chr1  151081985  151082078  3  500  +  1500

You can also use this tool to evaluate expressions. For example, computing "c3>=c2" for Input will result in the following:

chr1  151077881  151077918  2  200  -  True
chr1  151081985  151082078  3  500  +  True

or computing "type(c2)==type('') for Input will return:

chr1  151077881  151077918  2  200  -  False
chr1  151081985  151082078  3  500  +  False