User Tools

Site Tools


doc:substract

Substract Whole Dataset

Tool version

0.1

Keywords

Selection, Lines, Differences, Datasets

Summary

Subtracts an entire dataset from another dataset.

Description

This tool subtracts an entire dataset from another dataset. The subtraction can be restricted to user defined columns for tab-delimited files.

General comments (Warning/Tips)

You can restrict the subtraction to specified columns only if the input files are tab-delimited.

Blank and comment lines are skipped. They are not included in the output.

Duplicate lines are eliminated from both datasets. If any duplicate lines were eliminated, the number is displayed in the resulting history item.

If begin column is specified but end column is not: end column will be set to begin column automatically (and vice versa).

An empty dataset is output if both input files are identical or if you didn't selected the input files in the right order.

Input

  • Subtract: select the first input file. Any text format is valid.
  • from: select the second input file. Any text format is valid.
  • Restrict subtraction between 'begin column': this option is available only if the files are TAB delimited.
  • and 'end column': this option is available only if the files are TAB delimited.

The begin column must be less than or equal to the end column. If it is not, begin column is switched with end column.

  • Ignore empty columns and whitespace at end of line when subtracting: check the checkbox if you don't want to take into account empty columns and whitespaces at end of line.

Output

The output dataset contains the lines of the second input file which are not in the first input file.

Example

Usage Example: identifying the differences between two datasets.

Input

Subtract: file_dataset1.txt

from: file_dataset2.txt

Restrict subtraction between 'begin column': c1

and 'end column': c4

With file_dataset1.txt containing:

And file_dataset2.txt containing :

Output

Edited on

July 23rd, 2014

doc/substract.txt · Last modified: 2014/11/28 17:05 by slegras