Institute of Bioinformatics Münster
Table Search

Table Search is a small program that reads a text file (in general a CSV (=comma separated values) file) and displays the content in a table. The column numbers in each line of the file must be the same as the header, otherwise an error is displayed.

  • The "Field Separator" specifies the separator between fields in a line of input. If you need a tabulator, enter "TAB" here. If the fields are separated by multiple blanks and/or tabs enter "SP" here.
  • The field "Comment" specifies the sign where a comment starts. A comment allways ends at the end of the line.
  • The field "Has Header" specifies if the input file's first line is a header line. If so, the values are put in the table's header, otherwise the tables header line will have "Column n" entries and all lines of the input file are in the table.

To load a file, click on the button "File" and select the file. Immediately after selecting the file, the data is loaded - what can take some time. Note: If the input file is very big (which means much more than 2000 lines), the loading process can be very slow and the browser seems to hang, which is not the case, since the browser is very active with the data.

In the displayed table below the green header title there is a line for selection input, which provides the possibility to search for specific values. Enter search values and click on top the "Search in Data" button and cell rows with that condition are displayed.

Search fields for numeric data have yellow color and the possibility to search for a range, by entering a minimum and/or maximum value.

Search fields for text have green color and are "multi valued", what means every selection field may contain one or more conditions to search for. Every condition is separated from the others by blanks, and specifies a whole word. They are logically combined as "and" conditions. The wildcards "*" and "." are used for unknown parts in the column values - where "*" stands for an arbitrary number of unspecified characters (even zero!) and "." for a single character. The search is case insensitive. Examples:

  • "chr* BLANK *MM" will search for words (which could be two different words!) one starting with "chr" AND one ending with "MM", note: everything is case insensitive! Note: BLANK defines the key on your keyboard.
  • "pre*are*" will search for words starting with "pre" and have "are" somewhere after "pre".

2015-04-29 15:22