10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hello experts, I have matrices sorted by position, there are 400k rows, 3000 columns.
ID CHR POS M1 M2 M3 M4 M5
ID1 1 1 4.6 2.6 2.1 3.5 4.2
ID2 1 100 3.6 2.9 3.2 2.6 2.5
ID3 1 1000 4.1... (9 Replies)
Discussion started by: senhia83
9 Replies
2. Shell Programming and Scripting
Hi,
i was tried using the awk command for replacing '-' in the second column. but the below command replacing the entire file.
cat 1.txt |awk '{gsub(/-/,"")}1'
Input file
1,2,3,-4,5,6
1,-2,3,4,5,-6
1,2,3,4,5,6
1,-2,3,4,-5,6
Output file
1,2,3,-4,5,6
1,2,3,4,5,-6
1,2,3,4,5,6... (3 Replies)
Discussion started by: onesuri
3 Replies
3. Shell Programming and Scripting
Hi,
Please help with this.
I have several excel files (with and .xlsx format) with 10-15 columns each.
They all have the same type of data but the columns are not ordered in the same way.
Here is a 3 column example. What I want to do add the alphabet
from column 2 to column 3, provided... (9 Replies)
Discussion started by: newbie83
9 Replies
4. Shell Programming and Scripting
Hello,
I have some tab delimited data and I need to move the last col. I could hard code it,
awk '{ print $1,$NF,$2,$3,$4,etc }' infile > outfile
but it would be nice to know the syntax to print a range cols.
I know in cut you can do,
cut -f 1,4-8,11-
to print fields 1,... (8 Replies)
Discussion started by: LMHmedchem
8 Replies
5. UNIX for Advanced & Expert Users
Hello everyone,
I am writing a script to process data from the ATP world tour.
I have a file which contains:
t=540 y=2011 r=1 p=N409
t=540 y=2011 r=2 p=N409
t=540 y=2011 r=3 p=N409
t=540 y=2011 r=4 p=N409
t=520 y=2011 r=1 p=N409
t=520 y=2011 r=2 p=N409
t=520 y=2011 r=3 p=N409
The... (4 Replies)
Discussion started by: imahmoud
4 Replies
6. Shell Programming and Scripting
SW_dist_intr false Enable SW distribution of interrupts True
autorestart true Automatically REBOOT OS after a crash True
boottype disk N/A False
capacity_inc 1.00 ... (7 Replies)
Discussion started by: maxim42
7 Replies
7. Ubuntu
Hello,
I have a 1.6 GB file that I would like to modify by matching some ids in col1 with the ids in col 1 of file2.txt and save the results into a 3rd file.
For example:
File 1 has 1411 rows, I ignore how many columns it has (thousands)
File 2 has 311 rows, 1 column
Would like to... (7 Replies)
Discussion started by: sogi
7 Replies
8. HP-UX
Hi All,
I am talking about unix col(1) command used for some reverse line filtering etc.
And I notice that the stdout of this command is line buffered i.e. the stdout will flush the data in its buffer line by line. So the number of writes performed by stdout are more.
So now if I make stdout... (0 Replies)
Discussion started by: sunilsbjoshi
0 Replies
9. UNIX for Dummies Questions & Answers
Hello every1.
Can any1 help me with the col command.
Wat is a reverse line feed.
Which kind of files u need to use the col command. (2 Replies)
Discussion started by: rahulrathod
2 Replies
10. UNIX for Advanced & Expert Users
Hi All,
I am talking about unix col(1) command used for some reverse line filtering etc.
And I notice that the stdout of this command is line buffered i.e. the stdout will flush the data in its buffer line by line. So the number of writes performed by stdout are more.
So now if I make stdout... (0 Replies)
Discussion started by: sunilsbjoshi
0 Replies