|
|
Sponsored Content
Top Forums
UNIX for Dummies Questions & Answers
Row to Columns
Post 302111454 by dennis.jacob on Wednesday 21st of March 2007 07:44:15 AM
03-21-2007
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
hi,
I have a input file like
a,123,456,789,012,.......,b
I need to change the output file into
a,123,b
a,456,b
a,789,b
a,012,b
a,...,b
like that..
how to achieve that through UNIX................. (5 Replies)
Discussion started by: aaha_naga
5 Replies
2. Shell Programming and Scripting
I have a file that looks like this...
a
b
c
d
e
f
g
h
i
I would like to it to be like this
a b c
d e f
g h i
Thanks (8 Replies)
Discussion started by: elbombillo
8 Replies
3. Shell Programming and Scripting
Hi,
I have a question for Row to Columns by script.
e.g. i have a file
Start
1 2
3
4
End
Start
1 2
3
3
4
4
End (6 Replies)
Discussion started by: bleach8578
6 Replies
4. UNIX for Dummies Questions & Answers
Dear Unix Gurus,
I have a sample data set that looks like this
y1 y2 y3 y4 y5
x1 0.3 0.5 2.3 3.1 5.1
x2 1.2 4.1 3.5 1.7 1.2
x3 3.1 2.1 1.0 4.1 2.1
x4 5.0 4.0 6.0 7.0 1.1
I want to open it up so that I get
x1 y1 0.3
x2 y1 1.2
x3 y1 3.1
x4 y1 5.0
x1 y2 0.5
x2 y2... (3 Replies)
Discussion started by: tintin72
3 Replies
5. Shell Programming and Scripting
I have awk command to print column 8
awk '/select/ {print $8}'
which will print column 8
But I need to print 3, 5 and 8 column in a row and each column should be de-limited by "\t"
Hope anyone help me quickly. (2 Replies)
Discussion started by: elamurugu
2 Replies
6. Shell Programming and Scripting
i ask to do ,,program that convert the last row to be the first row ,,,and after that exchange the the columns
ex,,
1 2 3
4 5 6
7 8 9
to be
7 8 9
4 5 6
1 2 3
and then to be
9 8 7
6 5 4
3 2 1
give mee the code .... (0 Replies)
Discussion started by: khaled1989kh
0 Replies
7. UNIX for Dummies Questions & Answers
i ask to do ,,program that convert the last row to be the first row ,,,and after that exchange the the columns
ex,,
1 2 3
4 5 6
7 8 9
to be
7 8 9
4 5 6
1 2 3
and then to be
9 8 7
6 5 4
3 2 1 (0 Replies)
Discussion started by: khaled1989kh
0 Replies
8. UNIX for Dummies Questions & Answers
Hi All!
if I have a file like this:
8 10 12 14 16 18 0 2 6
2 4 6 8 10 12 16 18 10
6 8 12 16 18 0 2 2 6
2 2 2 2 2 2 2 2 2
10 12 16 4 8 16 4 16 0
8 10 14 16 0 4 8 12 14 And I want to divide all the lines by line 4 for example... (6 Replies)
Discussion started by: cosmologist
6 Replies
9. UNIX for Dummies Questions & Answers
Hi,
I have a tab-delimited file as follows:
1 1 2 2 3 3 4 4
a a b b c c d d
5 5 6 6 7 7 8 8
e e f f g g h h
9 9 10 10 11 11 12 12
i i j j k k l l
13 13 14 14 15 15 16 16
m m n n o o p p
The output I need is:
1 1 a a 5 5 e e 9 9 i i 13... (5 Replies)
Discussion started by: mvaishnav
5 Replies
10. Shell Programming and Scripting
Gents
Using the attached file
and using this code.
awk '{print substr($0,4,2)}' input.txt | sort -k1n | awk '{a++}END{for(i in a) print i,a}' | sort -k1 > output
i got the this output.
00 739
01 807
02 840
03 735
04 782
05 850
06 754
07 295
08 388
09 670
10 669
11 762 (8 Replies)
Discussion started by: jiam912
8 Replies
LEARN ABOUT DEBIAN
csv2mipe
CSV2MIPE(1) User Contributed Perl Documentation CSV2MIPE(1) NAME
csv2mipe.pl - Generates MIPE file based on 3 tab-delimited files based on MIPE version v1.1 arguments: * tab-delimited file with PCR-level data * tab-delimited file with SNP-level data * tab-delimited file with assay-level data Columns in file with PCR-level data: pcr_id pcr_modified (might be multiple, divided by semi-colon ";") pcr_project (might be multiple, divided by semi-colon ";") pcr_researcher (might be multiple, divided by semi-colon ";") pcr_species source_type source_id design_seq primer1_oligo primer1_seq primer1_tm primer2_oligo primer2_seq primer2_tm design_remark (might be multiple, divided by semi-colon ";") use_seq use_revcomp use_remark (might be multiple, divided by semi-colon ";") pcr_remark (might be multiple, divided by semi-colon ";") Columns in file with SNP-level data: pcr_id snp_id snp_pos snp_amb snp_remark (might be multiple, divided by semi-colon ";") Columns in file with assay-level data: pcr_id snp_id assay_id assay_type assay_enzyme assay_oligo assay_specific assay_tail assay_strand assay_remark (might be multiple, divided by semi-colon ";") SYNOPSIS
csv2mipe.pl <pcr_file.csv> <snp_file.csv> <assay_file.csv> ADDITIONAL INFO
See http://mipe.sourceforge.net AUTHOR
Jan Aerts (jan.aerts@bbsrc.ac.uk) perl v5.14.2 2005-07-20 CSV2MIPE(1)