Used in: gor/nor


The COLUMNREORDER command reorders the columns specified to the beginning of the column list. The rest of the columns will then appear after the specified columns.


gor ... | COLUMNREORDER column-list [-t]


The following query will take the first five rows of chromosome 1 from the #dbsnp# table, keep the Chrom, POS and Allele columns in the front and then the rest of the columns in maintained order.

gor -p chr1 #dbsnp# | TOP 5 | COLUMNREORDER Chrom,POS,Allele