03-13-2013
Reading column header
Hi,
I have some 10 tab delimited flat files, for some files the column header starts from 1st row whereas for some other files the column header starts from row or row 3 or row4 and so on....
Is there any way in UNIX so that we can read the column headers dynamically.'
I am new to UNIX, so please help.
Thanks,
Goutham
10 More Discussions You Might Find Interesting
1. Linux
say i have these many file in a directory named exam.
1)/exam/newfolder/link.txt.
2)/exam/newfolder1/
and i create a tar say exam.tar
well the problem is,
when i read the tar file i dont find any metadata about the directories,as you cannot create a tar containig empty directories.
on the... (2 Replies)
Discussion started by: Tanvirk
2 Replies
2. Shell Programming and Scripting
$ cat log.txt
Name Age Sex Lcation nfld alias xsd
CC 25 M XYZ asx KK Y
BB 21 F XAS awe SS N
SD 21 M AQW rty SD A
How can I replace the column with header "Lcation" with the column with header "alias" and delete the "alias" column?
so that the final output will become:
Name Age Sex... (10 Replies)
Discussion started by: jkl_jkl
10 Replies
3. Shell Programming and Scripting
i have a script that access the database and then returns some row. but in the command prompt it it not showing the column header. how to get that ?
below the script:
------------------------------------------------------------------------
#!/bin/ksh
.... (4 Replies)
Discussion started by: ali560045
4 Replies
4. Shell Programming and Scripting
Hello all,
We are trying to run a script in Oracle DB from AIX.
We need to set the Column Header while executing the query to generate the Output.
For eg.
select city, name from emp;
It need to generate report in .csv format as
CITY NAME
atla tom
cincin jack
How I... (1 Reply)
Discussion started by: velappangs
1 Replies
5. Shell Programming and Scripting
Hi All,
I have a file example.csv which looks like this
GrpID,TargetID,Signal,Avg_Num
CSCH74_1_1,2007,61,256
CSCH74_1_1,212007,647,679
CSCH74_1_1,12007,3,32
CSCH74_1_1,207,299,777
I want the output as
GrpID,TragetID,Signal-CSCH74_1_1,Avg_Num
CSCH74_1_1,2007,61,256... (4 Replies)
Discussion started by: Vavad
4 Replies
6. UNIX for Dummies Questions & Answers
Hi All,
I have a file example.csv which looks like this
GrpID,TargetID,Signal,Avg_Num
CSCH74_1_1,2007,61,256
CSCH74_1_1,212007,647,679
CSCH74_1_1,12007,3,32
CSCH74_1_1,207,299,777
I want the output as
GrpID,TragetID,Signal-CSCH74_1_1,Avg_Num
CSCH74_1_1,2007,61,256... (1 Reply)
Discussion started by: Vavad
1 Replies
7. Shell Programming and Scripting
Hi,
I have an input like this
1 2 3 4
2 3 4 5
4 5 6 7
I would like to count the no. of columns and print a header with a prefix "Col".
I would also like to count the no. of rows and print as first column with each line number with a prefix "Row"
So, my output would be
... (2 Replies)
Discussion started by: jacobs.smith
2 Replies
8. Shell Programming and Scripting
hello,
can someone helpe me on below issue.
i have a list of names and IDs,
mick 3424
noah 134
samuel 787
jack 434
i want to add a head for both colum using awk or sed or any tool
output
NAME ID
mick 3424
noah 134
samuel 787 (10 Replies)
Discussion started by: Sara_84
10 Replies
9. UNIX for Dummies Questions & Answers
Hi,
I have a txt file with multiple columns and i want to substitute the header of the first column.
Example:
Seq. Name Seq. Length #Hits min. eValue mean Similarity #GOs GOs Enzyme Codes InterProScan
comp1000201_c0_seq1 ---NA--- 337 0 0 -
comp1000297_c0_seq1 ---NA--- 612 0 0 -... (4 Replies)
Discussion started by: alisrpp
4 Replies
10. Shell Programming and Scripting
Hello,
I am trying to store sum of a column as a new column inside a file but have to find the column names dynamically
I/p
c1,c2,c3,c4,c5
10,20,30,40,50
20,30,40,50,60
If i want to find sum only column c1, c3 and output it as c6,c7
O/p
c1,c2,c3,c4,c5,c6,c7
10,20,30,40,50,30,70... (6 Replies)
Discussion started by: mkathi
6 Replies
LEARN ABOUT DEBIAN
mcxmap
mcxmap(1) USER COMMANDS mcxmap(1)
NAME
mcxmap - permute or remap the indices of graphs and matrices.
SYNOPSIS
mcxmap -imx fname (input) [-o fname (output)] [-make-map (output map file name)] [-make-mapc (output map file name)] [-make-mapr (output map
file name)] [-cmul a (coefficient)] [-cshift b (translate)] [-rmul c (coefficient)] [-rshift d (translate)] [-mul e (coefficient)] [-shift f
(translate)] [-map fname (row/col map file)] [-rmap fname (row map file)] [-cmap fname (column map file)] [-mapi fname (row/col map file
(use inverse))] [-rmapi fname (row map file (use inverse))] [-cmapi fname (column map file (use inverse))] [-tab fname (read (and map) tab
file)]
DESCRIPTION
This utility relabels graphs or matrices. Its main use is in applying a map file to a given matrix or graph. A map file contains a so called
map matrix in mcl format that has some special properties (given further below). The functionality of mcxmap can also be provided by mcx, as
a mapped matrix (i.e. the result of applying a map matrix to another matrix) is simply the usual matrix product of a matrix and a map
matrix. However, mcx will construct a new matrix and leave the original matrix to be mapped alone. When dealing with huge matrices, consid-
erable gains in efficiency memory-wise and time-wise can be achieved by doing the mapping in-place. This is what mcxmap does. In the
future, its functionality may be embedded in mcx with new mcx operators.
The special properties of a map matrix are
o The column domain and row domain are of the same cardinality.
o Each column has exactly one entry.
o Each row domain index occurs in exactly one column.
These properties imply that the matrix can be used as a map from the column domain onto the row domain. An example map matrix is found in
the EXAMPLES Section.
OPTIONS
-o fname (output file)
Output file.
-imx fname (input file)
Input file.
-map fname (row/col map file))
-rmap fname (row map file)
-cmap fname (column map file)
-mapi fname (row/col map file (use inverse))
-rmapi fname (row map fil (use inverse))
-cmapi fname (column map fil (use inverse))
Different ways to specify map files.
-make-map (output map file name)
-make-mapc (output map file name)
-make-mapr (output map file name)
Generate a map that maps the specified domain onto the appropriate canonical domain and write the map matrix to file.
-cmul a (coefficient)
-cshift b (translate)
These options have affect if neither a column map file nor column canonification is specified. If any of the first two options is used,
column indices i are mapped to a*i+b.
-rmul c (coefficient)
-rshift d (translate)
These options have affect if neither a row map file nor row canonification is specified. If any of the first two options is used,
indices i are mapped to c*i+d.
-mul e (coefficient)
-shift f (translate)
If a map file is specified for a given domain, neither a map file nor canonification is specified. If any of the first two options is
used, the indices i will be mapped to e*i+f.
-tab fname (read (and map) tab file)
This option requires the -map option. mcxmap will output the mapped tab definition.
EXAMPLES
The matrix below has two canonical domains which are identical. It denotes a map of the canonical domain onto itself, in which node 0 is
relabeled to 8, node 1 is relabeled to 5, et cetera.
(mclheader
mcltype matrix
dimensions 12x12
)
(mclmatrix
begin
0 8 $
1 5 $
2 3 $
3 2 $
4 4 $
5 6 $
6 7 $
7 9 $
8 1 $
9 10 $
10 11 $
11 0 $
)
AUTHOR
Stijn van Dongen.
SEE ALSO
mcxio(5), mcx(1), mcxsubs(1), and mclfamily(7) for an overview of all the documentation and the utilities in the mcl family.
mcxmap 12-068 8 Mar 2012 mcxmap(1)