rowsToCols

Reference Code backup Executable files

Convert rows to columns and vice versa in a text file (transpose)

Category

Generic

Usage

rowsToCols in.txt out.txt

Manual

This tool is part of UCSC Genome Browser's utilities.

Required arguments

  • in.txt: Input text file containing data to be processed.
  • out.txt: Output text file where the converted data will be written.

Options

  • -varCol: Rows may have various numbers of columns.
  • -tab: Fields are separated by tab.
  • -fs=X: Fields are separated by the given character X.
  • -fixed: Fields are of fixed width with space padding.
  • -offsets=X,Y,Z: Fields are of fixed width at the given offsets X,Y,Z.

Notes

This tool doesn't support empty/blank lines. If the input file has empty ending lines, you may observe error messages like:

Expecting 2 columns got 0, line 3 of input.txt

Examples

$ cat input.txt
a	b
c	d

$ rowsToCols input.txt output.txt

$ cat output.txt
a	c
b	d

Share your experience or ask a question