Table converter

Description

This tool selects, reorders and renames table columns. It can also be used to convert text files into tables.

Parameters

  • Column list: Selects columns to be printed. You can use comma separated lists of column numbers (like 3,1,5), and ranges of column numbers (like 9-14).
  • New column names: Add new header row for the selected columns. Use comma separated lists of column names (like source,date,name). By default the first imported row is used as a header row.
  • Column separator: Chipster uses tabulator as a column separator. If you wish to convert a text file into a Chipster table, you can change other column separators such as space, semicolon (;), colon (:), comma (,) and pipe (|) to tabulator.
  • First row to read: Skip the first few lines of the input file. Note that in table files, the header row is considered as the first row.
  • Does the first column of the input file have a title: Choose No if the first column does not have a title (this is typical for tables produced by the R-based tools in Chipster).

    Details

    Note that you must in all cases explicitly define the number of the columns that will be selected to the result table.

    Output

    Output is a table file.